Changed or Updated property?
You could save the file on the activate event (or change Thisworkbook.Saved
= true). then in the deactivate event, you could check Thisworkbook.Saved.
If true, no change. If false, there has been a change. [Lightly tested]
Other than that you would have to detect the change yourself (possibly using
the change event).
Note that changing Thisworkbook.Saved can affect the prompt to save before
closing.
--
Regards,
Tom Ogilvy
"Stefi" wrote in message
...
Hi All,
Is there any way to check if any cells in a worksheet has been changed? I
want to use a Worksheet_Deactivate() event, but only if there was a change
in
the sheet to avoid lengthy processing.
Thanks,
Stefi
|