Solved

Macro Security Settings need to be Low

Posted on 2008-06-12
3
2,566 Views
Last Modified: 2008-07-16
We have a Citrix farm, with 3 node servers. I need to be able to set the Macro security settings to 'Low' for all users. I know the reg key that controls macro security settings:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security

But I need to run a script to set this for All users. Has anyone got any ideas please?
0
Comment
Question by:leejrob
3 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 21767564
Are you sure setting macro security to low is your answer since this makes users susceptible to virus infection.

Where you need all users to run a macro why not purchase macro certification and sign the files to support auto acceptance of the macros.

Chris
0
 

Author Comment

by:leejrob
ID: 21767791
Not an option for us, that would be the case in an ideal world.

We have Mcafee 8.5, contolled by EPO on all our Citirx servers.
0
 
LVL 10

Accepted Solution

by:
JaredJ1 earned 500 total points
ID: 21770149
I would use group policy. You can either put a script in the User Configuration>Scripts area so that all users logging on will have the script launched during login. Or, you can scrap the script and use the Microsoft Office group policy template and set macro security in there. The template files are a better option in my opinion. There are also many other features that you can set for users. You can download the template files from the Microsoft site.
http://www.microsoft.com/downloads/details.aspx?FamilyID=BA8BC720-EDC2-479B-B115-5ABB70B3F490&displaylang=en

Let me know if you need more help applying them.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delete all words in cell more than 5 words 7 47
Problem to With line 4 41
After updating data my Excel graphs are showing too many dates 8 32
increment numbers by 10 11 29
Citrix policies are the most efficient method to configure and tune XenDesktop environments, allowing organizations to control connection, security and bandwidth settings based on various combinations of users, devices or connection types.  Citrix …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now