View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lew Schwartz Lew Schwartz is offline
external usenet poster
 
Posts: 5
Default 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