finding last edited cell

22strider

Active Member
Joined
Jun 11, 2007
Messages
299
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

22strider

Active Member
Joined
Jun 11, 2007
Messages
299
Hi, I was hoping to have a macro, running which would highlight last unsaved/edited cell.
Regards,
Rajesh
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
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.
 

Forum statistics

Threads
1,089,675
Messages
5,409,665
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top