to Frank Kabel Please

[Steved]

Hello Frank from Steved
You gave me the below Function which I am using.

Is it possible also to use the below function to update
=Docprops when a change is made to a cell in a worksheet.

The objective for the above is the Date will Update, if
any Cell is updated in WorkSheet.
Thankyou

=DocProps("Last save time")

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

 

[Frank Kabel]

Hi
this will get you the last saved date. So if you only change a cell
this function won't get any new result (as the saved date hasn't
change).
If you need a timestamp have a look at
http://www.mcgimpsey.com/excel/timestamp.html

 

[Guest]

Thankyou Frank.

-----Original Message-----
Hi
this will get you the last saved date. So if you only change a cell
this function won't get any new result (as the saved date hasn't
change).
If you need a timestamp have a look at
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany



.