Making a custom toolbar available to others

  • Thread starter Thread starter DKS
  • Start date Start date
D

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?
 
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
 
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
 
Back
Top