Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Footer help please
Thanks Gord.
Can you please lead me with baby steps to create the macro then save it? I also like to make the footer a default for all new sheets/books. How can I do this too? The footer to display the saved file name in 8pts. Cheers Ben "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Not possible AFAIK without changing default Font at ToolsOptionsGeneral which is a global setting for all new Excel workbooks. You probably wouldn't like the 8 pt font for column and row headers as well as default font size in cells. I suggest a quick macro saved in your Personal.xls Sub Set_Footer_Font() With ActiveSheet.PageSetup .LeftFooter = "&""Arial,Regular""&8" End With End Sub That will set the font size to 8 pt for whatever you enter as a left footer. Which could also be set in the above macro. Gord Dibben MS Excel MVP On Mon, 01 Dec 2008 23:31:11 GMT, "bwong" wrote: I would like to make a change so it becomes default. It is in Print Preview - Setup - Header/Footer tab. I want to make the font size 8 as default, I think the current default is 10. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Footer | Excel Discussion (Misc queries) | |||
Excel footer to look like Word footer? | Excel Discussion (Misc queries) | |||
Footer help.... | Excel Discussion (Misc queries) | |||
Footer | Setting up and Configuration of Excel | |||
footer | New Users to Excel |