Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Toolbar
I have created a custom Toolbar - with three Custom Buttons on, each running a Macro within the workbook. I want to be able to email the workbook to several users who need to use the Macros (by clicking the appropriate button on the toolbar) Problem is when I email it to another user, firstly he can not see the custom toolbar... then if he right clicks on the top part of Excel and makes the toolbar visible...none of the buttons are still inside... (but the Macros obviously have followed the workbook around...) Any Ideas...? (I know it works with text boxes.. but that clutters the screen and not on different sheets within workbooks.... Thanks again D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Toolbar
Here is an article which talks about attaching toolbars:
http://www.microsoft.com/exceldev/articles/toolbatt.htm Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm Here is another article or two you might find useful: http://msdn.microsoft.com/library/ba...n_addins97.htm http://www.microsoft.com/exceldev/tips/addins.htm -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... I have created a custom Toolbar - with three Custom Buttons on, each running a Macro within the workbook. I want to be able to email the workbook to several users who need to use the Macros (by clicking the appropriate button on the toolbar) Problem is when I email it to another user, firstly he can not see the custom toolbar... then if he right clicks on the top part of Excel and makes the toolbar visible...none of the buttons are still inside... (but the Macros obviously have followed the workbook around...) Any Ideas...? (I know it works with text boxes.. but that clutters the screen and not on different sheets within workbooks.... Thanks again D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Toolbar
Works fantastic!!!! ... Follow up question is I want to add TWO buttons instead of one.... I think the relevant part of the VBA script isis : ' Add command button control to the control's ' collection of CommandBar objects. With cbrCommandBar.Controls Set cbcCommandBarButton = _ .Add(msoControlButton) If I want to add another button can I just reapeat the last line, ie.Add(msoControlButton2) (I would assume u need to call it 2...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Toolbar
Yes, you just repeat the command.
-- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Works fantastic!!!! ... Follow up question is I want to add TWO buttons instead of one.... I think the relevant part of the VBA script isis : ' Add command button control to the control's ' collection of CommandBar objects. With cbrCommandBar.Controls Set cbcCommandBarButton = _ .Add(msoControlButton) If I want to add another button can I just reapeat the last line, ie.Add(msoControlButton2) (I would assume u need to call it 2...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Toolbar | Excel Programming | |||
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 |