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