Dear friends
Does anyone know how to set up page numbers in the footer that wil
print continuously across worksheets preserving the print area alread
made? I give you a example. I have 3 worksheets: WS1, WS2, WS3. I
every worksheet there are 3 pages to print. The print area is alread
defined in each worksheet but, unfortunately, in page setup for eac
worksheet is defined a different proportion (57% of normal dimension
65% and 68%). I would not change this proportion and I would like t
obtain this result:
WS1:page1, WS1page2, WS1page3, WS2page4, WS2page5…..
I tried to select all sheets and to setup page number in the footer bu
the result was not good because the print area was changed.
Someone can help me?
Thank yo

--
Message posted from http://www.ExcelForum.com

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut
would do what you want in VBA.

If you simply want to do it manually, set the print settings for each
page one at a time with scaling, print range, headers, footers, etc.
Then select all three pages and print. If you select all three pages
and try to change any print setting, all three pages have all print
settings set to the same settings as in the current page setup dialog.

71paolo71 < wrote:
Dear friends
Does anyone know how to set up page numbers in the footer that will
print continuously across worksheets preserving the print area already
made? I give you a example. I have 3 worksheets: WS1, WS2, WS3. In
every worksheet there are 3 pages to print. The print area is already
defined in each worksheet but, unfortunately, in page setup for each
worksheet is defined a different proportion (57% of normal dimension,
65% and 68%). I would not change this proportion and I would like to
obtain this result:
WS1:page1, WS1page2, WS1page3, WS2page4, WS2page5…..
I tried to select all sheets and to setup page number in the footer but
the result was not good because the print area was changed.
Someone can help me?
Thank you


---
Message posted from http://www.ExcelForum.com/