| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding author details to a footer
is it possible to add author detials to a footer, in the same way you can add
file details, time stamp etc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding author details to a footer
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| header and footer problems | Charts and Charting in Excel | |||
| Please help with Adding a Footer or Header | Excel Discussion (Misc queries) | |||
| Inserting Footer - Ajit | Excel Discussion (Misc queries) | |||
| Adding a Name Box in a Chart or Footer | Charts and Charting in Excel | |||
| Formatting a footer with a top border-line | Excel Discussion (Misc queries) | |||
Linear Mode
