Trusted Documents in Microsoft Office

[GRitchie]

Hello,

I've been trying to find a way to stop the 'enable content' warning to pop up on one specific document.

 

I have created a database that all staff will be using, however on launch macros run straight away to hide the ribbon etc.

These wont run unless 'enable content' is pressed; the problem is, a lot of staff will not realise this is the case and could potentially mess with the back end of the database.

 

 

 

I've seen a few powershell scripts to add trusted locations, however these didn't really seem to work.

PLUS I had to run a batch command to allow powershell from all locations first AND this has to be ran as an admin - so this isn't really an option! :-(

 

Help!

[localzuk]

You can specify trusted locations using the Office Adminsitrative Templates in Group Policy.

 

Use New Group Policy Settings to Manage Office 2010

 

Office 2007/2010 Trusted locations GPO - Spiceworks

 

Those are the details for 2010, but they are similar for other versions too - just get the correct ADMX files and you should be able to sort it out easily.

[GRitchie]

You can specify trusted locations using the Office Adminsitrative Templates in Group Policy.

 

Use New Group Policy Settings to Manage Office 2010

 

Office 2007/2010 Trusted locations GPO - Spiceworks

 

Those are the details for 2010, but they are similar for other versions too - just get the correct ADMX files and you should be able to sort it out easily.

 

Looks like this is the best way to do it, but I'm not sure on a few things:

1) Do I need 32 and 64 bit templates if there are different PC's in the network running both?

2) Can I just import the ADMX files within the GPO or do I need to go to the %systemroot% folders etc.?

3) Is this a user policy or computer? I would presume computer, but I'd prefer to verify it!

[localzuk]

1) Yes - however, I'd question why you're using Office 64bit, even Microsoft advise against it unless you're specificially in need of huge amounts of memory for, say, a spreadsheet (but that'd be a *huge* spreadsheet).

2) You need to add them to the domain controller's %systemroot% \sysvol\domain\policies\PolicyDefinitions and %systemroot%\sysvol\domain\policies\PolicyDefinitions\language folders (that way they get shared out everywhere).

3) They're user based as far as I know, but I'm going from memory.