ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   toolbar or icon in a add-ins (https://www.excelbanter.com/excel-programming/376338-toolbar-icon-add-ins.html)

guedj54

toolbar or icon in a add-ins
 
Hi,
How can I had a toolbar or an Icon to and Add-ins , so that that
toolbar/Icon will appear each time the add-ins is loaded.
(the toolbar/Icon suppose to actovate a macro called MyMacro)
Many thanks.

Paul

Jim Cone

toolbar or icon in a add-ins
 
Paul,
Code similar to this in the ThisWorkbook module...

Private Sub Workbook_AddinInstall()
ToolbarButtonCreate 'call sub
End Sub

Private Sub Workbook_AddinUninstall()
ToolbarButtonRemove 'call sub
End Sub
------------
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"guedj54"
wrote in message
Hi,
How can I had a toolbar or an Icon to and Add-ins , so that that
toolbar/Icon will appear each time the add-ins is loaded.
(the toolbar/Icon suppose to actovate a macro called MyMacro)
Many thanks.

Paul


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com