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