Do I copy the 3 lines below into the sheets code? or do I have to add some
text, sorry but I am new to VBA?

"Gary''s Student" wrote:

If someone suggests a solution without VBA, ignore this response.

Function lastsaved() As Double
lastsaved = ActiveWorkbook.BuiltinDocumentProperties(12)
End Function

just enter:
=lastsaved()
in any cell.
--
Gary''s Student
gsnu200705


"debbieevans" wrote:

Is there a way to display last date modified on a worksheet without running a
macro and always in the same cell?