Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Footer on Page Two
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Footer on Page Two
One way:
http://mcgimpsey.com/excel/subs/firstfooter.html In article , Pepper wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Footer on Page Two
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? "JE McGimpsey" wrote: One way: http://mcgimpsey.com/excel/subs/firstfooter.html In article , Pepper wrote: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Footer on Page Two
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. In article , Pepper wrote: 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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Footer on Page Two
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 "JE McGimpsey" wrote: 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. In article , Pepper wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
Footer set up start Page 2 | Setting up and Configuration of Excel | |||
print footer on every page (Totals on every page) | Excel Discussion (Misc queries) | |||
Footer on last page? | Excel Discussion (Misc queries) | |||
header and footer on every page except the first page? | Excel Discussion (Misc queries) |