Setting macro security level to "low" permanently?

[Guest]

Hi,
Whenever you open a new Excel sheet, the macro security level is set to
"Medium" by default. How can I set to be "low" permanently?

 

[Dave Peterson]

This is an application setting that should stick the way you set it.

I think that visit to your IT department is still in order.

Or did you try them and they gave you a response that didn't jibe with your
other thread.

 

[Frank Kabel]

Hi
I would suspect that this is a setting done by your IT department to
prevent secrutiy level 'Low'.

 

[Guest]

Hi Dave,
I got the IT people to look at this. They tried to help, but could not. We
tried setting the HKEY variable and the whole nine yards. In the end, I was
told that Microsoft does not allow the security level to be set permanently
to LOW. Somehow, I don't buy that. I think this can be set via one of the
HKEY variables. Would you happen to know which? I have Excel 2000 (9.0.7616
SP-3). Your help/opinion will be greatly appreciated.

 

[Dave Peterson]

I use xl2k at work (under win2k). I have security set to low. (I only open
workbooks that should be opened at work!)

I've never seen it change from what I set it (via the dialog, too!).

I use xl2002 at home under win98SE and I can have it set for low (but at home, I
sometimes open workbooks that I shouldn't!), so I have it set for medium.

But my setting is always remembered and never changed on either pc.

From a previous post:


The Excel security setting is saved in the registry under this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security

This is for Excel 2003. Should be something similar for other versions.

The item is "Level". You'd set this to 2 for medium

===

and just to add: 1 = low, 2 = medium, 3 = high.
And 11.0 is xl2002.

So for xl2k, you'd want 10.0

 

[Bill Seaton]

Hi,
Whenever you open a new Excel sheet, the macro security level is set to
"Medium" by default. How can I set to be "low" permanently?

 

[Mark Campbell]

As one can see the problem, what is the solution to permanently set the macro
settings to "low" when it always reverts back to "medium"? I have tried on
numerous occcasions, without success, to set the level to low through the
Trust Center (Excel 2007 - Office Professional package). When it was loaded

 

[Manny]

I have the exact same issue. I am using my home computer (ie no IT etc..). It
is running excel 2007 on Vista. When I used to run my excel 2003 on XP, the
macro security setting would permanently stay at low. Now with Vista,
whenever I set it to low, it goes back to high whenever I re-open the
spreadsheet. Is Windows Defender doing this?

Some of my friends complain of the same thing. They have to keep going back
to the trust centre to lower the security settings. Often, they will open the
spreadsheet and try to run a macro. It will state that macros are disabled
and you need to change the security settings, close the workbook and re-open
it under the new settings.

Any solutions?

- Manny

 

[LarryN]

Only way I could permanently make macros work was to set security to low and
kill off several of the trust center settings having to do with signatures.
Unfortunate that they only way to use macros in our current environment is to
wipe the security settings out essentially completely. Overzealous security
design gets immediately changed to "no security at all".