Excel footer default font size

[Rhiannon Thomas]

I need to set up a default font size to be smaller than the worksheet font
size so that all worksheets have a file path footer that is a size 8.

I would prefer not to have to make a template and force everyone to start
new worksheets from the template. I need to make sure that ALL worksheets
have footers on them - including the current ones.

I was thinking a macro might be the way to go (but I have no idea how to do
that).

 

[Gord Dibben]

Without using a Template you are stuck with manually running a macro on
every worksheet or workbook either new or existing.

For all sheets..............

Sub Path_All_Sheets()
Set wkbktodo = ActiveWorkbook
For Each ws In wkbktodo.Worksheets
ws.PageSetup.LeftFooter = "&8&Z&F"
Next
End Sub

Stick it in an add-in which all users can access then require that they all
run the macro to set up the footer.


Gord Dibben MS Excel MVP