how do I show last date file saved?

I want a cell to show the last saved file date and not change every time I
open the file except when it is saved.

Try a UDF like


Function DocProps(prop As String)


Application.Volatile

On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
Exit Function

err_value:
DocProps = CVErr(xlErrValue)
End Function


and can be used like so


=DocProps("Last save time")



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pete" <Pete@discussions.microsoft.com> wrote in message
news:03FBE66D-A05C-4664-A555-5D1D4F2B44EC@microsoft.com...
> I want a cell to show the last saved file date and not change every time I
> open the file except when it is saved.