Last saved By in the footer of a print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to get the name of the person which has saved the workbook in
the footer of the printout. What must I do?
 
something like this...

sheets("Sheet1").Pagesetup.leftfooter =
thisworkbook.BuiltinDocumentProperties("last saved author")

This should be all on one line. You can add this to the print event if you
want it to be dynamic... Post back if that was your intention...
 
Hi Jim.

It works!

The value was ..."last author" not "last saved author". Add it in the
procedure ...sub woorkbook_beforeprint() and it works like I wanted.

Thank you very much :-)
 
You must log in or register to reply here.

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

Change Header/Footer w/ Worksheet Option Buttons 1
Adding code right after the "Save As" dialog box 2
PowerPoint Separate lines (line break) - PowerPoint Footer 1
adding footer to all existing sheets in workbook and also to newsheets which is added 1
Excel Footer 1
Excel Unique last page footer 1
Workbook Page Numbers 1
Putting the document number custom property in workbook 1

Back
Top