Sharing macros - extreme newbie question I know.

  • Thread starter Thread starter rfalke
  • Start date Start date
R

rfalke

I have a macro to create a menu, but how do I make it run when they ad
the add-in? I assume that this has to happen automatically. Thanks

--rya
 
Put a call to the macro in the Workbook_Open event (in the thisworkbook
module) in the Addin.

See Chip Pearson's site for an explanation of Events

http://www.cpearson.com/excel/events.htm

Make sure you include code to delete it (surrounded by On Error Resume Next
and On Error goto 0 in case it doesn't exist) before you create it so you
don't get duplicates.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing macros - extreme newbie question I know. 1
Excel VBA-How do I increment columns in VBA? 1
Pasting cell contents into a macro 1
How to call Excel add-in macro from a button… 1
Sharing Macros 1
Distributing A Custom Menu 8
How to use OFFSET in VBA 1
Custom Menu Bar in Excel 2007 21

Back
Top