Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Registry Key for Macro Security Level?


Hey folks. I tried to find this on the web and on my own computer, and
was unable to. Does anyone know of a way to change the macro security
setting via the registry?

More specifically, I plan to push this registry key out to the rest of
the network to set macro level to 'medium' on all our computers.
Alternate ideas are welcome.

Thanks.


--
ph8
------------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=393249

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Registry Key for Macro Security Level?

It's Level under:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

Change the 11 to 10 for Excel 2002 or 9 for Excel 2000.

--
Jim
"ph8" wrote in message
...
|
| Hey folks. I tried to find this on the web and on my own computer, and
| was unable to. Does anyone know of a way to change the macro security
| setting via the registry?
|
| More specifically, I plan to push this registry key out to the rest of
| the network to set macro level to 'medium' on all our computers.
| Alternate ideas are welcome.
|
| Thanks.
|
|
| --
| ph8
| ------------------------------------------------------------------------
| ph8's Profile:
http://www.excelforum.com/member.php...o&userid=19871
| View this thread: http://www.excelforum.com/showthread...hreadid=393249
|


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Registry Key for Macro Security Level?

Jim Rech wrote:
It's Level under:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

Change the 11 to 10 for Excel 2002 or 9 for Excel 2000.

No way!, you can also trust access to vb project this way!

Not very secure
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Registry Key for Macro Security Level?


Perfect! Thanks for your help, Jim

--
ph
-----------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987
View this thread: http://www.excelforum.com/showthread.php?threadid=39324

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Registry Key for Macro Security Level?

hiya guys this thread helps us loads, after we unsuccessfully tried to
implement via Group Policy - the policy setting didnt stick - so we used
this reg key to force it. Has anyone else had issues with GP and the excel
security setting namely the "trust VB project setting"???


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
Not able to KEEP Macro Security Level At Minimum Carl Excel Discussion (Misc queries) 2 March 5th 06 08:17 AM
set macro security level through VBA bill_morgan Excel Programming 4 August 1st 05 06:29 PM
Detecting Macro Security Level Ed Ferrero[_5_] Excel Programming 0 June 15th 04 01:22 PM
Detecting Macro Security Level arkimediz Excel Programming 0 June 15th 04 11:47 AM
Using VBA to change macro security level Tracey[_4_] Excel Programming 4 January 23rd 04 07:20 PM


All times are GMT +1. The time now is 09:14 AM.

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

About Us

"It's about Microsoft Excel"