Disable Workbook_Open() Macro

D

Dan

I have a workbook that runs the Workbook_Open() code every time you open it.
There are some times I would like to open the workbook without running the
macro. Is there a way to disable the macro on Open (For example in Access
you can hold down the Shift key while opening the DB and it won't exceute the
autoexec macro)

Any suggestions are appreciated.
Thanks!
 
R

Ron de Bruin

Hi Dan
The same in Excel if you use File>Open
If you open the file by double clicking on it in Explorer it will not work
 
B

Bob Umlas

Same in Excel -- hold the shift key down while opening the workbook; the
event won't fire.

Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
How to apply a macro to all workbooks 2
VBA word change keys 0
Hotkey in proper workbook 2
Unable to change ActiveSheet within Workbook_Open 2
open a workbook without running Workbook_Open macro in E2007 10
Open workbook without running Workbook_Open Event 5
Sorting a protected worksheet 1

Top