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

When you say that the security level is not active I assume you mean it is
disabled so you cannot change it. I don't know what registry entry would
cause that. But the entry that holds the current security level is "Level",
a dword entry under:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

A "1" = None, "2" = medium, etc.

Btw, this has nothing to do with the AutomationSecurity property, which is
something entirely different. There is no programmatic way to change the
security level as far as I know.

--
Jim
wrote in message
oups.com...
| 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
|

Jim, thatnk U for the reply...
per your advice i check hkey security level and it's set to 2 (from
what U mentioned in your email 2 is Medium)...but when i open up
spreadsheet which has workbook_open()routine excel instantiates that
procedure without warning...
cheers
D.

Jim Rech wrote:
When you say that the security level is not active I assume you mean it is
disabled so you cannot change it. I don't know what registry entry would
cause that. But the entry that holds the current security level is "Level",
a dword entry under:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

A "1" = None, "2" = medium, etc.

Btw, this has nothing to do with the AutomationSecurity property, which is
something entirely different. There is no programmatic way to change the
security level as far as I know.

--
Jim
wrote in message
oups.com...
| 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
|