View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default Button to execute Add-in

Excel 2003

Tools-Customize-Toolbars-New
Enter the name you want...
Click on Commands Tab and choose Macros and drag the Custom Button to the
new toolbar then Right Click on the button, choose Assign Macro and pick your
Macra

You can dock the new toolbar anywhere you want...

Assign your macro to the tool bar...

"Aerojade" wrote:

I have created an Excel add-in that executes a simple function(pops up a
messagebox). I did this by adding a new Module in the VB editor. How can i
create a custom button in the toolbar to execute this function. PLease help.