You need to cancel the OnTime event procedure. See
www.cpearson.com/excel/ontime.htm for details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"bdcrisp" wrote in message
...
I have a workbook that, as part of its function, uses the
onTime command
to refresh a particular sheet. When you exit the file however,
it tries
to reopen it ( a box with enable / disable macros) pops up
again. Is
there a quick fix for this - a bit of code to stop all macros
prior to
closing?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide
to creating financial statements