If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Macro security
Hi,
Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? |
#2
|
|||
|
|||
Macro security
This is a setting that's kept in the Windows Registry. If your system
administrators don't want you to save changes there, you'll want to complain to them. Maybe they can make you the single exception??? DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? -- Dave Peterson |
#3
|
|||
|
|||
Macro security
Excel's macro security level settings are saved in the Registry.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security On rightside window Level should be 2 for medium. Perhaps you do not have sufficient rights to alter the Registry. Someone with administrator rights may have to make the changes. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? |
#4
|
|||
|
|||
Macro security
I consulted my registry setting as explained by you i.e.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security For LEVEL I see the data as 2, type is REG_DWORD. I suppose this is what you are referring to? If that is the case, then how come I do not get a prompt asking me to ENABLE or DISABLE macros or NOT TO OPEN the file? Thanks in anticipation. "Gord Dibben" wrote: Excel's macro security level settings are saved in the Registry. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security On rightside window Level should be 2 for medium. Perhaps you do not have sufficient rights to alter the Registry. Someone with administrator rights may have to make the changes. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? |
#5
|
|||
|
|||
Macro security
The entire DWORD value looks like 0x00000002(2)
If that is the case then I don't know why your Excel keeps defaulting to "Low" In Excel ToolsOptionsSecurity set the level to "medium" then close Excel. Re-open. Has the setting stuck? Gord On Thu, 26 Oct 2006 12:36:08 -0700, DKS wrote: I consulted my registry setting as explained by you i.e. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Security For LEVEL I see the data as 2, type is REG_DWORD. I suppose this is what you are referring to? If that is the case, then how come I do not get a prompt asking me to ENABLE or DISABLE macros or NOT TO OPEN the file? Thanks in anticipation. "Gord Dibben" wrote: Excel's macro security level settings are saved in the Registry. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security On rightside window Level should be 2 for medium. Perhaps you do not have sufficient rights to alter the Registry. Someone with administrator rights may have to make the changes. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? Gord Dibben MS Excel MVP |
#6
|
|||
|
|||
Macro security
Yes, the setting is exactly as you mention.
Thanks for the help, but it seems that I am once again stuck with a completely abnormal situation. FYI: I did change the security setting as you requested, closed Excel, restarted excel and the setting is back to LOW. "Gord Dibben" wrote: The entire DWORD value looks like 0x00000002(2) If that is the case then I don't know why your Excel keeps defaulting to "Low" In Excel ToolsOptionsSecurity set the level to "medium" then close Excel. Re-open. Has the setting stuck? Gord On Thu, 26 Oct 2006 12:36:08 -0700, DKS wrote: I consulted my registry setting as explained by you i.e. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Security For LEVEL I see the data as 2, type is REG_DWORD. I suppose this is what you are referring to? If that is the case, then how come I do not get a prompt asking me to ENABLE or DISABLE macros or NOT TO OPEN the file? Thanks in anticipation. "Gord Dibben" wrote: Excel's macro security level settings are saved in the Registry. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security On rightside window Level should be 2 for medium. Perhaps you do not have sufficient rights to alter the Registry. Someone with administrator rights may have to make the changes. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? Gord Dibben MS Excel MVP |
#7
|
|||
|
|||
Macro security
Shrug......slap forehead.......and leave.
I don't know what's happening. Will keep playing and might come up with something. I googled the Excel groups and all I could find was basically same as Dave's and my own thoughts. Gord On Fri, 27 Oct 2006 01:21:02 -0700, DKS wrote: Yes, the setting is exactly as you mention. Thanks for the help, but it seems that I am once again stuck with a completely abnormal situation. FYI: I did change the security setting as you requested, closed Excel, restarted excel and the setting is back to LOW. "Gord Dibben" wrote: The entire DWORD value looks like 0x00000002(2) If that is the case then I don't know why your Excel keeps defaulting to "Low" In Excel ToolsOptionsSecurity set the level to "medium" then close Excel. Re-open. Has the setting stuck? Gord On Thu, 26 Oct 2006 12:36:08 -0700, DKS wrote: I consulted my registry setting as explained by you i.e. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Security For LEVEL I see the data as 2, type is REG_DWORD. I suppose this is what you are referring to? If that is the case, then how come I do not get a prompt asking me to ENABLE or DISABLE macros or NOT TO OPEN the file? Thanks in anticipation. "Gord Dibben" wrote: Excel's macro security level settings are saved in the Registry. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security On rightside window Level should be 2 for medium. Perhaps you do not have sufficient rights to alter the Registry. Someone with administrator rights may have to make the changes. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote: Hi, Currently I have Excel 2003 on XP operating system. In the past, before migrating to this advanced version, I had macro security set to MEDIUM whereby everytime I open a spreadsheet that contains macros the Excel software prompts me if I would like to enable or disable the macros. With the migration to Excel 2003, I cannot seem to re-establish this setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS - MACRO - MACRO SECURITY. But via both means, after setting the security to MEDIUM, i close .xls and re-open it using a workbook containing macros and there is absolutely no prompt. On re-verifying the option settings I discover that it has switched back to LOW. How can I permanently re-establish this setting? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
Thread Tools | |
Display Modes | |
|
|