How can I enter the "Last saved by" field to my spreadsheet?

what is VBA?

i had to google how to add the date/time too because they changed so much in Excel - there's not "quick parts" anymore and i can't figure out how to add the fields I need.

last author is one of them.

So, do I just type in the cell: XXX = ThisWorkbook.BuiltinDocumentProperties("Last Author")

I don't have that - I don't have the "quick parts" or the "text" option. Only the text box. That's what I'm saying - what is supposed to be there is not there!

I don't get it!

Hilary

You can use VBA to achieve your aims of having last saved by field.

If you want to try here's one way by installing this User Defined Function (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

With your workbook open hit Alt + F11 to go to Visual Basic Editor.

Or Developer>Visual Basic to go to the Editor.

CTRL + r to open Project Explorer if you don't see it.

Select your workbook/project and right-click>insert>module.

Paste the DocProps Function into that module.

Alt + q to return to the Excel window.

Save workbook

In a cell enter this formula

="Last saved by " & DOCPROPS("author")

Gord

Note: there are other properties you can pull if you wanted.  Examples are. . . .

'=DOCPROPS("last save time")
'or
'DOCPROPS("creation date")

Dave AFAIK Quick Parts is available in Word and Outlook, not Excel

Gord

Excel 2016

Version 1803

it's annoying, but fine if it can't be done. I really like having that as an option for when others get into the shared drive and mess with my stuff - I know who to go to -

I know I know, I can keep a local copy, but I'm not allowed. I have to keep it in the shared access folder. I don't want to do track changes - although I will check that out as an option! thanks.