Stop Auto_Open Macro

okcheung

New Member
Joined
Jan 1, 2005
Messages
22
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?
:eek:
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

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

kind regards,
Erik
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,877
Members
409,668
Latest member
mitunsLax

This Week's Hot Topics

Top