You could attach the toolbar to each person's Personal macro workbook (via
View, Toolbars, Customize, Attach in the first tab). However, you would need
to open each of their peronal.xls files on a machine that has the toolbar
already installed which could be awkward.

Wouldn't it be easier all around to put all the macros you want them to have
onto a new workbook and then save it as an add-in (with the toolbar attached
to it as described above)? This .xla file could then be saved once to a
shared folder and then that folder specified as the startup location for
everyone's Excel: Tools, Options, General tab (this can be done via GPO if
you're using Active Directory). This approach has the advantage of being
centralised and avoiding messing with everyone's individual personal.xls.

"jeffbert" wrote:

I have created a custom macro toolbar that we want to deploy to about 3 to 4
users. I have already updated everyone's Personal macro workbook with the
updated macros. How can I put the updated macro toolbar in each user's Excel,
without overwriting all of their other settings? I know that all of the
settings for Excel are stored in an "xlb" file and I could replace their file
with mine, but then they would lose all of their other settings. Any
suggestions?