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..