adding author details to a footer

D

dave nicholls

is it possible to add author detials to a footer, in the same way you can add
file details, time stamp etc
 
K

Kevin B

You can use this macro to insert the Author name into the footer:

Sub Author()

ActiveSheet.PageSetup.CenterFooter = ActiveWorkbook. _
BuiltinDocumentProperties("Author").Value

End Sub
 
Top