Hi,
i have spreadsheets with macros in Workbook_Open() and i need to open
one of them in a macro disable mode to prevent macro run..

i've just moved from XL2K to 2003 and im trying to change security
level through ToolsMacroSecurity same way as ive always been doing
it in XL2K but somehow Security option is not ACTIVE so i can't click
on it (is some settings in excel i should check/uncheck to make it
active?)

I also tried to do the trick through the code
(application.AutomationSecurityAutomationSecurity= msoAutomationSecurityForceDisable)
by putting it into debugger or creating new spreadsheet with that code
inside..

?Application.AutomationSecurity
3
the above check shows that excel is in macro disable mode but if i open
a spreadsheet with macro in Workbook_Open() excel instantiates a
macro..

anyone can explain how to deal with the issue
thank U in advance
Dim