Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 12:11 AM
Arobind
 
Posts: n/a
Default Setting macro security level to "low" permanently?

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" wrote:

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.

Arobind wrote:

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



  #2   Report Post  
Old December 22nd 04, 01:41 AM
Dave Peterson
 
Posts: n/a
Default

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\E xcel\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



Arobind wrote:

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" wrote:

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.

Arobind wrote:

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



--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Removing Unnecessary Macro Security Warnings o0icebox0o Excel Discussion (Misc queries) 1 November 30th 04 12:09 AM


All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017