Thanks for clearing up how to fix the floating toolbar. What do I do If I
just want to share a custom toolbar with no macro at all?

Also, If I ever updated this add-in, would it be automatically changed in
excel or would the users need to remove it and reinstall the add-in? If
that's so I'd rather look for another way of sharing the toolbar.

Is there a way that you can go into Excel's registry to change it's path to
the toolbar file? That to me sounds like it would be the easiest way.

"Dave Peterson" wrote:

I don't understand what you mean by a macro button.

The code at Debra's site creates a toolbar with icons that can be clicked to run
the macros.

If you don't like it floating...

You can change this portion:

.Position = msoBarFloating
to
.Position = msoBarTop
or
.Position = msoBarBottom

Personally, I like to float it in the window. The user can move it to where
they want, but I figure that they'll notice that it was added!

Eric wrote:

Thank you for your replys,

I tried the instructions that were given but it only shows how to do it with
a macro button. How do I write the VBA code for a custom toolbar that is not
floating in addition to a macro button that is on the toolbar with regular
buttons?

"Gord Dibben" wrote:

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.



--

Dave Peterson