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

Sub Author()

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

End Sub

--
Kevin Backmann


"dave nicholls" wrote:

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