You should give this a quick look...

http://www.cpearson.com/excel/AppEvent.htm
--
HTH...

Jim Thomlinson


"The unFriendly XTech IT Dept" wrote:

Hello,

I would like to create an Add-In or some other method that would run some
code when every workbook is open and when every workbook is closed.

I am aware of the Workbook_open event and the beforeClose event but how do I
program my add in to run code at those times, for everything that open or
closes?

Thanks,
Kevin
The Disgruntled XTech IT Dept