View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Add icon to toolbar

just have the Workbook_Open event add a temporary button to the appropriate
toolbar.

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus

--
Regards,
Tom Ogilvy


" wrote:

I want to (as part of my XLA addin in he XLStart folder) have an icon
appear automatically on the toolbar to run a function within that
project.

I am hoping to be able to present a single xla file to be copied in the
xlstart folder, that will basically keep the end users from doing
anything other then clicking on the icon it creates.

Any other information/suggestions/comments (outside the specific
question) is also very welcome.