View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel footer default font size

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


On Thu, 25 Sep 2008 15:11:20 -0500, "Rhiannon Thomas"
wrote:

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