How to put excel into batch mode
This is an addition to my other questions. In order for me to automate my
processes, it's important for excel not to do anything that might put it
into a wait state. So far I've dealt with the following:
AutomationSecurity on high (3) to disable macros
DisplayAlerts to false Prevents modal dialogs (does excel have non-modal
dialogs?)
AskToUpdateLinks = false Don't query to pull in data from the internet.
Is there anything else that should be on this list?
-Lew
|