excel 2000 Date is updated

[Steved]

Hello from Steved Using Excel 2000

If I change any cell in a worksheet is it possible to have
a date in say cell B2 is updated to show when the sheet
was last updated.

Thankyou

 

[Frank Kabel]

Hi
try the following UDF:
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

Now you can use the following formula in one of your cells:
=DocProps("Last save time")

 

[Steved]

Thankyou Frank

-----Original Message-----
Hi
try the following UDF:
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

Now you can use the following formula in one of your cells:
=DocProps("Last save time")


--
Regards
Frank Kabel
Frankfurt, Germany


.