Running Macro from a Template

[shekhu]

Hi All,

I need to put the macro into a word template in the server and then open the template from a different location in a network and run the macro on it. While doing so, it is fine at the server, but when I open the template from another location I get a message and the macro is not run (image attached). Can anyone suggest me a solution to it.

[Jay Freedman]

If this is in Word 2007 or 2010, go to the Options dialog, click Trust Center, then the Trust Center Settings button. In the Trust Center dialog, click Trusted Locations. At the bottom, check the box for "Allow trusted locations on my network". Then click "Add new location" and select the folder on the server that contains the template.

In Word 2003 there were pre-set trusted locations (e.g., your Templates folder) but you couldn't add new ones.