Code for all workbooks
 

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

Code for all workbooks
 

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

Code for all workbooks
 

Thanks Jim I'll work on it

Thanks,
Kevin
The Disgruntled XTech IT Dept



"Jim Thomlinson" wrote:

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