Button for macro on toolbar

[adyan76]

Hello experts,

I have a macro which I want to sent to many people and I want by opening this macro a button is put on toolbar and the button action is assigned to this macro.

Is this possibe and where i will have to put the code?

Just suppose this is my code

sub test() 
msgbox "Test" 
end sub  

[royUK]

This example shows how to add a toolbar to a workbook

Add_Toolbar.zip

[buran]

Hello,
Put This one in a regular Module. It may be the one where your macro is or separate module.

Please Login or Register  to view this content.

and put this in ThisWorkbook Module

Please Login or Register  to view this content.