G
Guest
Excel 2003 - Does anyone know of a function or possible macro that
automatically will put the date the worksheet was last saved in cell A1 of a
spreadsheet. So when the user hits the save button this date gets
automatically updated. If the user just opens the spreadsheet but does not
do anything to it or save it then the date would not change.
A function would be best if possible as then the user doesn't have to accept
running macro's when they first open the spreadsheet. If that isn't possible
then some coding will do.
Thanks!
automatically will put the date the worksheet was last saved in cell A1 of a
spreadsheet. So when the user hits the save button this date gets
automatically updated. If the user just opens the spreadsheet but does not
do anything to it or save it then the date would not change.
A function would be best if possible as then the user doesn't have to accept
running macro's when they first open the spreadsheet. If that isn't possible
then some coding will do.
Thanks!