Not really.

Application.Workbooks.count

gives you the count of open workbooks.

--

Regards,
Tom Ogilvy


Todd Webb wrote in message
...
We need to monitor Excel's state relative to open
workbooks. We were advised to use events to track changes
in Excel's state. Our problem is that Excel's events are
ambiguous relative to the actual state change. Are there
any standard approaches to disambiguate scenarios such as:

the difference between save and save as
the difference between closing a workbook and canceling
the close
the difference between exiting Excel and closing the
final open workbook