ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Registry Key for Macro Security Level? (https://www.excelbanter.com/excel-programming/336484-registry-key-macro-security-level.html)

ph8[_16_]

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


Jim Rech

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
|



ph8[_17_]

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


David Welch[_2_]

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

rob maz

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


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com