finding last edited cell

[22strider]

Hello Friends,

Is it possible to find the unsaved data in a spreadhseet/workbook? Or the last cell was edited?

After working on multiple workbooks when I try closing them excel confirms if the changes should be saved or not. I was wondering if there was a way to check what those changes were. If there was a way to find address of the cell that was edited last. This will help figuring out if the file should be saved or not.

Regards,
Rajesh

 

[wigi]

Do you mean tracking changes?
Track changes in a shared workbook - Excel - Office.com

 

[22strider]

Hi, I was hoping to have a macro, running which would highlight last unsaved/edited cell.
Regards,
Rajesh

 

[wigi]

Hello,

That will be very easy and impractical, I'm afraid.
You should work with application-level events, which is not easy.

If you need to do this in a dedicated workbook, you could add an event macro in ThisWorkbook: the Workbook_SheetChange event.
It has a number of consequences, such as that the workbook now contains macros.