I tried adding the following function (from another post), in order to automate documenting the last date changed/saved and the author:

'-----------------------------------------------------
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 enter in a cell such as
=DocProps ("last author")
or
=DocProps ("last save time")
'-________________________________________________

I entered =DocProps("last author") in a cell, but get a "name" error.

Have I placed the Function in the wrong area? Add in problems?

Help appreciated.