View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan Drummond[_3_] Rowan Drummond[_3_] is offline
external usenet poster
 
Posts: 414
Default executing an add in

Hi Gary

The normal way to access Add-In functionality is to use the Add-In's
workbook_open event to add menu items (or toolbar buttons) that call the
add-in's macros. These menu items are then removed again by the
workbook_BeforeClose event.

Hope this helps
Rowan

Gary Keramidas wrote:
created a form and saved it as an add-in. how do i call the form
userform1.show does not work. created a code module in the xls that opens
the form, but that module is not available as a macro.

i want to invoke the form from a button the toolbar.

thanks