Excel footer default font size

  • Thread starter Thread starter Rhiannon Thomas
  • Start date Start date
R

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).
 
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
 
Back
Top