Thanks Bill. That was exactly what I needed. Now I can control what
happens when opening, saving or printing any worksheet. Fantastic!


On Nov 28, 2:46 pm, "Bill Renaud"
wrote:
I haven't used this particular feature myself, but take a look at the
following topics in Microsoft Visual Basic Help:

Application Object Events
Using Events with the Application Object

In Excel 2000, these topics are a little hard to find. Start with any
workbook event that has the "Using Events..." link in it, click on that,
then click on the "See also" link at the top of the page, to gradually
drill down to the "Application Object Events" topic.

You might also refer to a few pages on Chip Pearson's web site:

"Application Events" (http://www.cpearson.com/excel/AppEvent.aspx)
"Events And Event Procedures In VBA"
(http://www.cpearson.com/excel/Events.aspx)

--
Regards,
Bill Renaud