View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
future_vba_expert future_vba_expert is offline
external usenet poster
 
Posts: 26
Default disabling automatic startup of macro in vba

The MSDN site says that you can kill the auto start up of a macro if you hold
down the shift key while starting up the excel spreadsheet. I found that this
did not work for me. I have the macro under 'workbook_open', which I think
would apply. I sometimes have to edit the vba code, and would prefer that the
macro does not run at all at that time. The rest of the time we want it to
run without any prompts or messages (except for fata errors, of course).
Thanks for any help you can provide.
--
future_vba_expert