Function to enter users name and date when last modified?

[Neale Dickson]

Hi,

Hoping someone can provide an answer to the following Excel
(2002) query.

Is there a way I can automatically display the last
person/user who saved a spreadsheet plus the date in the
spreadsheet? OR have a macro that prompts people to enter
these details when they go to save?

Looking forward to your response,

Thank you
Neale

 

[Frank Kabel]

Hi
one way: you may use the following user defined function:
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


In your case with the following formulas in some cells
=DocProps("Author")
=DocProps("last saved time")