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!

Hi Dan

you can hold down the Shift key while opening the DB and it won't exceute
The same in Excel if you use FileOpen
If you open the file by double clicking on it in Explorer it will not work



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dan" wrote in message ...
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!

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

Bob Umlas
Excel MVP

"Dan" wrote in message
...
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!