You need to create an application-level event.
see Chip Pearson's page at
http://www.cpearson.com/excel/AppEvent.htm


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"jruppert" wrote in message
...

i would like to create an add-in that runs when any workbook is opened.
I didnt think i could use the workbook_open code b/c that would have to
reside in the individual workbooks, am i wrong in that assumption?

thanks.


--
jruppert
------------------------------------------------------------------------
jruppert's Profile:
http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread...hreadid=275605