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 setting (prin
area) is already defined in each worksheet but, unfortunately, in pag
setup for each worksheet is defined a different scale (70% of norma
dimension, 65% and 68%). I would not change this scale 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

This was answered the first time you asked it.

--
Regards,
Tom Ogilvy

"71paolo71 " wrote in message
...
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 setting (print
area) is already defined in each worksheet but, unfortunately, in page
setup for each worksheet is defined a different scale (70% of normal
dimension, 65% and 68%). I would not change this scale 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/

Paolo
You can use a formula in the footer, like:
&[Page]+3 of &[Pages]+6

for the WS2, etc

NickHK

"71paolo71 " wrote in message
...
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 setting (print
area) is already defined in each worksheet but, unfortunately, in page
setup for each worksheet is defined a different scale (70% of normal
dimension, 65% and 68%). I would not change this scale 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/

I tried your solution Nick, but it doesn't work good.
If I have 40 sheets, and each sheet contains more pages to print (wit
different print setting scale), I should put a formula in the footer o
each sheet. It' s very long time and, as well, the print setting scal
was changed.
By my opinion, It's necessary a VBA code but I don't know how write it

Someone can help us?
By

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