View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Button to execute Add-in

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 ToolsAdd-ins?

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


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 20:08:00 -0700, 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.