A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Macro security



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2006, 05:28 PM posted to microsoft.public.excel.setup
DKS
external usenet poster
 
Posts: 93
Default 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  
Old October 26th, 2006, 06:52 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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  
Old October 26th, 2006, 08:08 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old October 26th, 2006, 08:36 PM posted to microsoft.public.excel.setup
DKS
external usenet poster
 
Posts: 93
Default 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  
Old October 26th, 2006, 10:15 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old October 27th, 2006, 09:21 AM posted to microsoft.public.excel.setup
DKS
external usenet poster
 
Posts: 93
Default 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  
Old October 27th, 2006, 10:29 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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
  #8  
Old October 27th, 2006, 11:57 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Macro security

I've seen a couple of posts that describe a problem that the user couldn't
change the setting in xl2003 via the user interface because it was greyed out.

But this doesn't sound like the same situation as the OP's.

Here's one by Jan Karel Pieterse

==================

if you are using Excel 2003 the box in
macro security options is greyed out.

the registry setting was moved from user to machine
and you can no longer change it from the UI.

Run the program regedit.exe
goto:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Excel\Security
Add or Change a DWORD named AccessVBOM to Value 1


Changing the registry value changes the setting, but it stays grey.

Removing the registry entry effectively gives the control back to
Excel.

So: If you add that registry entry, the only way to change the "trust
access to VB projects" setting is by either removing the entry (and
then change it in Excel), or by changing it in the registry.

Sounds like an administrator sort of reg entry to enforce a security
setting on users.

Regards,

Jan Karel Pieterse
http://www.jkp-ads.com

==============
Maybe DKS can look for entry in the registry.

Remember to backup the registry before you turn your pc into a boat anchor!


Gord Dibben wrote:

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


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.