Author of Excel workbook appear in footer

  • Thread starter Thread starter Randy W
  • Start date Start date
R

Randy W

Is there a way/code to have the author of the excel file
appear automatically in the custom header/footer of an
Excel 97 file. Maybe some type of code. Any help would
be greatly appreciated.

Thank you.
 
Try this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PageSetup.RightFooter = ActiveWorkbook.BuiltinDocumentProperties("Author")
Next wkSht
End Sub

You must place it in the Thisworkbook module
When you print it will add the name in the footer

Right click on the Excel icon next to File in the menubar
choose view code
paste it in there
Alt-Q to go back to Excel
 
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

Is there an author field in Excel? 4
Custom information in Excel footer 8
Printing Excel File Custom Properties in the Footer 3
Custom Footer 2
PowerPoint Separate lines (line break) - PowerPoint Footer 1
Setting up Default Headers/Footers in Excel 3
Excel 2007 Header Doesn't Print 1
Create a Standard Footer 2

Back
Top