Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing page numbers
Hi all
I'm sure this is really easy, but I'm trying to put page numbers in an Excel report. The pages are on many different sheets, and are not the only data on each sheet, and are printed using a macro. I seem to keep going back to page 1 for each new sheet that I use. Can anyone tell me what I'm doing wrong? Thanks Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing page numbers
Try grouping the sheets and printing all at once.
-- Regards, Tom Ogilvy "richard bishop" wrote in message ... Hi all I'm sure this is really easy, but I'm trying to put page numbers in an Excel report. The pages are on many different sheets, and are not the only data on each sheet, and are printed using a macro. I seem to keep going back to page 1 for each new sheet that I use. Can anyone tell me what I'm doing wrong? Thanks Richard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing page numbers
Hi,
excel page numbering is more or less an automatic thing. and seems to be sheet specific. each time you change sheet, the numbering sequence resets. to do what you want you would have to turn off auto numbering and add the following code to your macro prior to EACH print... With ActiveSheet.PageSetup .rightheader = "" .centerheader= "" .leftheader= "page number of total pages" .rightfooter= "" .centerfooter = "" .leftfooter = "page number" end with you don't need all of the above, the the one where you want the page number to appear. and you will have to set the numbering sequence, the above is just examples. regards Frank -----Original Message----- Hi all I'm sure this is really easy, but I'm trying to put page numbers in an Excel report. The pages are on many different sheets, and are not the only data on each sheet, and are printed using a macro. I seem to keep going back to page 1 for each new sheet that I use. Can anyone tell me what I'm doing wrong? Thanks Richard . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing sheets with page numbers | Excel Discussion (Misc queries) | |||
Printing page numbers | Excel Discussion (Misc queries) | |||
Page numbers when printing multiple sheets | Excel Discussion (Misc queries) | |||
printing same excel sheet with page numbers | New Users to Excel | |||
Printing documents with page numbers | Excel Discussion (Misc queries) |