Create the Toolbar through VBA code and make it available to all.

Steps...............

Open a new file and add the code for creating a Toolbar. See below for help.

Save the file as an add-in.

Place the add-in in a common folder and instruct all users to load that add-in
and keep it loaded.

For help on creating a Toolbar see Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 05:58:00 -0700, Eric wrote:

I need to share a custom toolbar on the network so that when multiple users
use a common terminal with Excel, the custom toolbar will appear. I would
prefer having a single custom toolbar file so that there is only one file to
update from time to time and to make sure that everyone's toolbar is
identical.

I have Excel 2003. I believe something has to be done with the registry but
what I tried so far using instructions from Excel 97 hasn't worked so I'm out
of options.