Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a custom toolbar available to others
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a custom toolbar available to others
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 "DKS" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a custom toolbar available to others
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("M yControl) .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 "DKS" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding custom images to a button on custom toolbar | Excel Programming | |||
Custom face for custom toolbar item | Excel Programming | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |