Making a custom toolbar available to others

[DKS]

Hi,

I have created a custom toolbar in one of my .xls workbooks. I notice that
without my doing anything special (thus by default) the same toolbar is
available to me in every workbook that I open, or even if I create a new
workbook. That is excellent.

I wanted to make the same toolbar available to my colleagues. What must I
do in order for them to get this toolbar?

 

[FSt1]

hi
the most common practice is to record a macro that creates the custom tool
bar.
the file containing the macro could then be saved to a removable disc and
the disc transfered from pc to pc.
another common practice it when a custom tool bar is created for a special
file only.
code is added to create the tool bar at file open, then delete the tool bar
at file close.

regards
FSt1

 

[Matthew Pfluger]

Does the toolbar refer to any custom macros or simply built-in Excel
commands? If yes to macros, then you'll need to include that in your macro:

with Application.CommandBars("MyCommandbar").Control("MyControl)
.OnAction = "MyMacro"
end with

You'll also have to include a copy of those macros to the other users. This
is usually done by creating an add-in. I'll stop here in case you don't have
this need.

Matthew Pfluger