XL 2003 TOOLS/Macro/security level inactive

[dim1ann]

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 Tools>>Macro>>Security 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 Rech]

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\Excel\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
| 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 Tools>>Macro>>Security 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
|

 

[dim1ann]

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.