Stop Auto_Open Macro

[okcheung]

Dear all,
How can I stop the AUTO_OPEN Marco from running, I have password protected the VBA properties with the PWD on hand, but don't know how to do so.
Anyone can help?

 

[erik.van.geit]

Hi,

if you are talking about opening the workbook manually:
press SHIFT while opening the workbook

kind regards,
Erik

 

[Richard Schollar]

Hi

You could either: Disable macros on opening (dependent on what you have your security settings set at) or hold down Shift when you click to open the workbook which disables the firing of the Workbook_Open event.

Best regards

Richard

 

[okcheung]

Dear guys,
Thanks very much!!