toolbar or icon in a add-ins

[Guest]

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]

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" <[email protected]>
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