J Marro wrote:
Is the Auto_Close setting necessary in Excel 97?

Yes.

If you don't cancel the outstanding OnTime and you close the workbook but
don't close Excel, the workbook will be re-opened within the next minute to
run the macro!

I recall reading that 97
resets on close and does not need such routines to put settings back to
default.

That may be true for some settings - but not for most.

Plus I get an error message with that Sub in the workbook. I can't
recall the exact message but I'll note it tomorrow when I get back to work.

If you copied and pasted the code there should be no message (it works OK for
me). Only thing might be if you already had an Auto_Close procedure. In
that case, combine the two.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup