Set Security levels via macro

  • Thread starter Thread starter J. Shrimp, Jr.
  • Start date Start date
J

J. Shrimp, Jr.

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?
 
J.,

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

HTH,
Bernie
 
I don't believe you have programmatic control over the security levels. It
would be surprising if you did.
 
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\Excel\Security\Level

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

/i.
 
Back
Top