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? |
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? |
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? |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com