Custom Toolbar

[Darin Kramer]

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

 

[Tom Ogilvy]

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/backgrnd/html/msdn_addins97.htm

http://www.microsoft.com/exceldev/tips/addins.htm

 

[Darin Kramer]

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

 

[Tom Ogilvy]

Yes, you just repeat the command.