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

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

Thanks I will give that a try

"IanC" wrote:

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