Button to execute Add-in

[Aerojade]

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.

 

[Sheeloo]

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...

 

[Dave Peterson]

I would use code to create a new toolbar with all the buttons that run the
macros in your addin.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm
or
http://spreadsheetpage.com/index.php/tip/creating_custom_menus

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

 

[Gord Dibben]

Add-ins do not execute functions.

Add-ins are workbooks that contain macros or functions.

Did you open a new workbook, add a module and stick some code into that
module then save the workbook as an Add-in?

Have you loaded that add-in through Tools>Add-ins?

If so, see the other replies for executing the macro in that add-in.


Gord Dibben MS Excel MVP