How do I start Excel Footer on 2nd page?

[Guest]

I recently upgraded MS Office. What happened to capability click on
"different first page" so I can start footer on 2nd page?

 

[Debra Dalgleish]

Different first page has always been a feature in Word, but not in Excel.

In Excel, you could print the first page
Then add the footer, and print the remaining pages.

 

[Guest]

Thank you Debra. I appreciate your response.

I wonder if it would not be a simple thing for Miscosoft to enable one to do
the same thing in Excel that you can do in Word. I hope they will consider
this possibility.

 

[Jim May]

Put this in "ThisWorkbook" Event-code module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Const sFOOTER As String = "my footer"
Dim wsSheet As Worksheet
Cancel = True
Application.EnableEvents = False
For Each wsSheet In ActiveWindow.SelectedSheets
With wsSheet
.PageSetup.LeftFooter = ""
.PrintOut from:=1, To:=1
.PageSetup.LeftFooter = sFOOTER
.PrintOut from:=2
End With
Next wsSheet
Application.EnableEvents = True
End Sub