Last Saved By property

B

bodhi2.71828

I'm trying to set the Last Saved By property of several workbooks.
From another post on this newsgroup, I tried using:
Click to expand...

ActiveWorkbook.BuiltinDocumentProperties("Last Author").Value = "Jane
Smith"

but then after

ActiveWorkbook.Save
ActiveWorkbook.Close

the Last Saved By gets reset to the original name. So.... how can I
change the name that Excel thinks is me? That is, if Excel thinks I'm
"John Doe" for purposes of Author and Last Saved By, how can I change
that to say, "Jane Smith"? Is that a Windows setting? Thanks.

Also, when I right-click an Excel file and choose Properties, in the
Properties dialog that appears, for some Excel files there are General,
Custom, and Summary tabs, and for others there is only the General tab.
Strange. Is this because they were created with different versions of
Excel or something? Thanks.
 
L

Lyndon Rickards

Are you saying that Excel thinks you are someone else? Take a look
at Tools->Options->General->Username. (Excel 2000/2003 anyhow...)
This is where that SavedBy name comes from.

HTH - Lynn.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing Duplicate Entries 1
Create a small table from a large table by skipping empty columns 4
Last saved by 7
Drop downs and look up 4
Macro to look up and match names? 2
How to update last save time & last author for each worksheet 7
Help - I Need Excel VBA Help With Sorting and New Worksheets 6
"LAST SAVED BY".... (Help) 4

Top