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?