Diable Macros when openning a worksheet

[vestax22]

Hi, I have a worksheet which calls upon another worksheet to extract data. This worksheet is fairly large and contains macros at startup. I want to know if its possible to disable marcos at startup so that I could open and close the file quicker.

Thx in advance

 

[longhair]

vestax22,
while opening hit the esc key. this will break into the macro.

regards,

longhair

 

[combo]

In XP (don't know if this property exists in earlier versions of excel) you can do:
[tt]Application.AutomationSecurity = msoAutomationSecurityForceDisable[/tt]
and next open workbook (default is msoAutomationSecurityLow).

combo