Prev: HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?
Next: mail receipient option in excel in disabel ... How to enabl it?
From: bwong on 27 Apr 2010 22:16
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
news:a5v8j41m22q57sfmoag5fv3v1923k7tf51(a)4ax.com...
> Not possible AFAIK without changing default Font at Tools>Options>General
> 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" <bswong(a)bigpond.net.au> 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?
>>
>



 | 
Pages: 1
Prev: HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?
Next: mail receipient option in excel in disabel ... How to enabl it?