Thread: Custom Toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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!