Prev: Export to Word and keep formatting
Next: Excel 2010 Beta Professional
From: JMay on 30 Mar 2010 14:06
In certain files I work with the annoying feature above reacts and enters a
string of text as soon as I enter the first letter. I notice the ON/OFF
button is under Tools, Options (xl2003) and Office Button Options (xl2007).

These GLOBAL settings have always confused me as - I would like for this to
apply on a workbook by workbook basis, even a cell-by-cell basis, not every
cell in every workbook opened during a session.

I know that if I have a workbook where I want certian cell to be disabled I
can include in the Workbook_Open event macro

Application.EnableAutoComplete = False

Can I do more or less.. What's the best approach to solving this?

Thanks in advance..

Jim
 | 
Pages: 1
Prev: Export to Word and keep formatting
Next: Excel 2010 Beta Professional