Assigning macros located in a server folder to the Ribbon in Word 2010

Topic

New Reply

I have some custom macros stored in a folder on the server and I cannot work out how to add them to the Ribbon in Word 2010.

When I choose Customize Ribbon, add a Tab and then add a Group on that Tab and I select a Group and ‘Choose commands from’ then ‘Macros’ the list is empty. I assume Word is looking in the usual place where macros are stored on the local C: drive, but this is not where I want to store my custom macros, because people on the network need to be able to run them.

I would be very grateful for your assistance.

Regards
useful

Reply | Quote

Replies

You say they are stored in a folder – in what format are they?

Macros need to be stored in a template. That template can then be made available to people on the network. That same template is also where you would store the ribbon customisations. The template can then be loaded as an add-in (for global access in all word docs) or as the attached template (for access when the template is attached to a document).

Generally, we use the Workgroup Templates folder as the location for multiple users to access the shared template.

Reply | Quote

Thank you for your advice Andrew.

Regards
useful

Reply | Quote

The template needs to:
1- be “loaded” as an Add-In
2- be stored in a “Trusted Location” according to your security settings

If you want to do this for multiple people on your network, you do NOT want to be customizing the Ribbon using the Word Interface. This will give you many headaches.

Instead, you will want to create your own ribbon tabs and customizations in XML in your template. See Customize the Ribbon – It Doesn’t Take Rocket Science

Reply | Quote

Thank you Charles.

Regards
useful

Reply | Quote