See one answer in microsoft.public.excel.misc


Please don't post the same question to multiple groups - it just
tends to fragment your answers.


If you're not sure which group to post in, put both groups in the
To: header. That way replies will show up in both groups by default.


In article ,
"John Petty" wrote:

Is there a way that I can use a shortcut Key Sequence
(i.e. ctrl+a) to toggle the enable/disable of a function

command to be toggled:

Application.EnableAutoComplete = True
Application.EnableAutoComplete = False