Configuring Excel for Citrix users

[AndyE45]

We are trying to configure certain settings in Excel XP for our citrix users. We are trying to apply settings to all users as outlined by:

Set macro security to Medium. To do that, click the Tools menu, point at Macro, and click Security. On the Security Level tab, select Medium and click OK.
Trust add-ins and Visual Basic projects. To do that, click the Tools menu, point at Macro, and click Security. On the Trusted Publishers tab, select both the checkboxes at the bottom, and click OK.
Enable the add-in Excel functions. To do that, click the Tools menu, and click Add-Ins. From the list of available add-ins, select Functions Class, and click OK.

Using the MS Maintwiz.exe program we can set macro security to Medium but can't set the trust for VB projects. We also need to add an add-in but don't know how that's done either.

 

[enigma99]

AndyE45,
If you are trying to set a template for Office use the ORK tools and create a transform file (You should still be able to get the ORK tools from Microsoft...if not just do a search for ORK XP).
This will allow you to set default settings for the Office products and then create a transform file for your settings.

This should take care of it.
Hope that helps.

 

[AndyE45]

enigma,

Thanks for the info. The Maintwiz program essentially does most of what we needed but not quite all of it. I got the info for what I needed from another forum in the form of reg entries.

I'll keep what you said in mind though.

Thanks.