Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two Levels of Security in Database Tool. ASP Report Maker | Excel Worksheet Functions | |||
Security Levels and Macros | Excel Discussion (Misc queries) | |||
Macro - security levels | Excel Discussion (Misc queries) | |||
Macro security | Excel Discussion (Misc queries) | |||
macro security | Excel Discussion (Misc queries) |