Excel Date/Time Stamp when SS is changed

[danhauer]

Hello -

This seems like it should be easy, but I cannot find a way to write a formula to update a cell with the date/time of the last change on the spreadsheet. I can do it with code, but I need to pass this info on to users.

Is there a way? I tried convincing them that they could do a print preview and look at the footer witht the last date/time saved, but they didn't buy it. They want to see the last updated date in cell A1.

Thanks,

danhauer

 

[SkipVought]

Hi,
No way that I know of doing that without tying it to the worksheet change or workbook before save events. :-( Skip,
Skip@theofficeexperts.com