Sharing macros - extreme newbie question I know.
 

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

--
rfalk
-----------------------------------------------------------------------
rfalke's Profile: http://www.excelforum.com/member.php...fo&userid=1526
View this thread: http://www.excelforum.com/showthread.php?threadid=26893

Sharing macros - extreme newbie question I know.
 

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.

--
Regards,
Tom Ogilvy


"rfalke" wrote in message
...

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

--ryan


--
rfalke
------------------------------------------------------------------------
rfalke's Profile:
http://www.excelforum.com/member.php...o&userid=15269
View this thread: http://www.excelforum.com/showthread...hreadid=268935