Hi,

The xlCellChangedState enumeration constants are used to indicate whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed, so I don't think it is suitable for your needs.

Please would you describe a bit more about how you envisage the overall effect to work? The key considerations to this are:
(1) From what point are you remembering changes from?
(2) At what point does a synchronisation occur so they are no longer considered to be changes?

Depending on (1) and (2), the most obvious way to do this would be to have a hidden sheet which is identical to the one where the changes occur. When the user changes the sheet, you can have conditional formatting which highlights any differences between the two sheets.