How to Create and Deploy Macros to User Group

[cmosher]

Hi everyone -- I am charged with automating some functions that will format reports for a group of Non-IT users. What I would like to do is:

1. create a macro to add a tab to the ribbon for macros,
2. add the macros
3. deploy to about 3 dozen users

Does anyone have suggestions or experience for that? I am unclear if I would need to have specific features on each users workstation (such as a Custom UI?).

[Andy Pope]

Sounds like you need to create an addin.
The ribbon xml would be part of the addin. And you will need to edit the xml to add tab/group/buttons etc. You can use customui editor to do this.

The addin can then either be stored in a single folder that all users have access to, or distributed to them individually. The down side of individual files comes when you update the addin and have to ensure everybody has the latest version.