Footer on Page Two

  • Thread starter Thread starter Pepper
  • Start date Start date
P

Pepper

I have a worksheet that prints on two pages.
How can I get footer on second page only.
I can do it easily in Word, cant seem to figure this out for Excel 2003.
 
Thank you for the feedback.
I am having trouble getting it to work,
having changed the worksheet name in the code to the actual name, and I put
it into the VBA editor ALT+F11, Copy/Paste.
Does it matter if the worksheet of interest is not the only one, nor the
first at the left?
 
If you entered the correct worksheet name, the position of the sheet or
the number of sheets doesnn't matter.

Since you didn't mention what "trouble" means, it's hard to diagnose it
further.
 
I am sorry, I should have been more specific, you are not a mind reader
I modified the code to read (I pasted the code into the code window of the
VBA Editor)

Dim sFooter As String
With Sheets("survey stats")

Inserted the footer, and it still prints. Survey stats is the sheet name

Thank you very much
 
Back
Top