View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Raul[_2_] Raul[_2_] is offline
external usenet poster
 
Posts: 11
Default Open workbook without running Macros

Holding the shift key down while opening the file is exactly the type of
solution I was looking for.

Thank you very much,
Raul

"Dave Peterson" wrote:

You can change the security level to high (or medium and say no to the allow
macro prompt) to turn off all macros in that workbook (open the workbook after
you toggle this setting--it's not retroactive).

Or you could hold the shift key down while opening the file. This stops the
auto_open and workbook_open events, but doesn't disable all the macros (if you
need them later).

Raul wrote:

How can I manually open a workbook without the running macros that are set to
run when the workbook is opened?

Thanks in advance,
Raul


--

Dave Peterson