Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 10-01-2006, 11:07 PM   #1
Beta Member
 
Join Date: Sep 2006
Posts: 5
Default Excel 2003 SP2 Macro Security Level in Registry

Was just wondering if and where the security level for macros can be changed to medium within the registry. I have had a look around under current user key and havent been able to find what I was looking for. Hopefully this can be changed under current user so that admin rights wont be needed and it can be added into the log on script. I found a site where they had done it with excel 2003 but because we have service pack two this seems to have changed the location or completly removed this feature from current user?

Any help is much appreciated, I will keep digging.
__________________

pmt82 is offline   Reply With Quote
Old 10-02-2006, 05:41 PM   #2
Beta Member
 
Join Date: Sep 2006
Posts: 5
Default Re: Excel 2003 SP2 Macro Security Level in Registry

Well managed to find the remedy, and thought I would post it incase anyone else searches for it.

http://support.microsoft.com/kb/820739/en-us

I used that as a guide (the user key directory in regedit). Simply just create (if they havent been already) a "Security" key folder, and then DWORD named "Level". (you can skip doing this by going into the office program through tools, macros and security and changing it to a level, and the folder and DWORD will be created automatically). Modify the Dword with the number 1 for low or 4 for high or anything in between, such as 2 for medium.
Then export these changes and place the .reg file for all the modifications into your login script.
Example:
regedit /s %logonserver%\NETLOGON\RegistryEdits\OfficeMacroSe curity.reg

Hope this helps anyone else who dosent want to change a workstation at a time for all their users.
pmt82 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



All times are GMT -5. The time now is 05:27 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0