How make code execute for ANY active workbook?

[Chet Shannon]

Is there a way that I can make a given piece of code
execute on ANY spreadsheet that I open? What I mean is I
don't necessarily want to embed the code into one
spreadsheet. I would like the code to automatically
execute for any spreadsheet that I have open.

The code will be a workbook_beforePrint event but I want
this code to execute for ANY active worksheet upon the
workbook_beforePrint event occurring.

Thanks,
Chet

 

[Doug Glancy]

Chet,

Yes. Look in VBA help under Application Object Events (XL 2k). I was able
to puzzle it out from this.

Chip Pearson also covers them here at
http://www.cpearson.com/excel/AppEvent.htm

hth,

Doug