I'm not certain of the exact details, but how about a routine using the
Workbook_BeforeClose to copy the ranges (paste values) to another location
(another, possibly hidden, sheet) within the workbook, then another routine
to compare these values with the current values after opening?

--
Ian
--
"ranswrt" wrote in message
...
I have a sheet that is updated when it is activated. Is there a way to
check
if any or the ranges have been changed when it is updated and to identify
the
ranges that have been changed?
Thanks