Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Setting macro security level to "low" permanently?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Arobind - 27 Oct 2004 00:11 GMT
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 - 27 Oct 2004 02:58 GMT
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.

> 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?

Signature

Dave Peterson
ec35720@msn.com

Arobind - 22 Dec 2004 00:11 GMT
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.

> This is an application setting that should stick the way you set it.
>
[quoted text clipped - 6 lines]
> > 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 - 22 Dec 2004 01:41 GMT
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

> Hi Dave,
> I got the IT people to look at this. They tried to help, but could not. We
[quoted text clipped - 19 lines]
> > Dave Peterson
> > ec35720@msn.com

Signature

Dave Peterson

Frank Kabel - 27 Oct 2004 07:00 GMT
Hi
I would suspect that this is a setting done by your IT department to
prevent secrutiy level 'Low'.

Signature

--
Regards
Frank Kabel
Frankfurt, Germany


> 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?
Bill Seaton - 20 May 2008 19:12 GMT
> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.