Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook without running Macros
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook without running Macros
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macros in a protected workbook | Excel Discussion (Misc queries) | |||
Running Macros in protected workbook | Excel Worksheet Functions | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macros Running Slow in a Shared workbook | Excel Programming | |||
Running macros from another workbook | Excel Programming |