excel 2000 Date is updated

  • Thread starter Thread starter Steved
  • Start date Start date
S

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
 
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")
 
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


.
Click to expand...
 
Back
Top