Set Security levels via macro
 

I have a spreadsheet with a Save macro.
This macro should set the Security levels
for macros back to high when the spreadsheet
closes.
When I try to record a macro to that sets the
security level, no code is written to the macro.

What code will set the security level for macros?

Set Security levels via macro
 

J.,

You can't modify security levels with a macro - it is not exposed to
VBA.

HTH,
Bernie


"J. Shrimp, Jr." wrote in message
...
I have a spreadsheet with a Save macro.
This macro should set the Security levels
for macros back to high when the spreadsheet
closes.
When I try to record a macro to that sets the
security level, no code is written to the macro.

What code will set the security level for macros?

Set Security levels via macro
 

I don't believe you have programmatic control over the security levels. It
would be surprising if you did.

--
Regards,
Tom Ogilvy

"J. Shrimp, Jr." wrote in message
...
I have a spreadsheet with a Save macro.
This macro should set the Security levels
for macros back to high when the spreadsheet
closes.
When I try to record a macro to that sets the
security level, no code is written to the macro.

What code will set the security level for macros?

Set Security levels via macro
 

You might consider using the Windows API or WScript's Shell object to modify
entries in the registry. The key to modify is:

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

Set 11.0 in the path above to the version of Office the end user is using.

/i.


"J. Shrimp, Jr." wrote in message
...
I have a spreadsheet with a Save macro.
This macro should set the Security levels
for macros back to high when the spreadsheet
closes.
When I try to record a macro to that sets the
security level, no code is written to the macro.

What code will set the security level for macros?