Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not able to KEEP Macro Security Level At Minimum | Excel Discussion (Misc queries) | |||
set macro security level through VBA | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Using VBA to change macro security level | Excel Programming |