setting print
 

I have 40 sheets and each sheet contains more pages to print. The prin
setting scale is not the same for all sheets. I would like to numbe
(progressive number) and print all pages without lost the settin
print already made. Is it possible with a VBA code?
Someone can help me

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

setting print
 

Pippo,

record a macro while changing the first page number to Auto in a single
sheet. Then remove all the stuff except that one item. Then make it loop
through all the sheets.

For each MySheet in Sheets()
... code... ' using MySheet
next MySheet

Change any reference to the sheet in the macro code (probably "Activesheet")
to MySheet.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"pippo100 " wrote in message
...
I have 40 sheets and each sheet contains more pages to print. The print
setting scale is not the same for all sheets. I would like to number
(progressive number) and print all pages without lost the setting
print already made. Is it possible with a VBA code?
Someone can help me?


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

setting print
 

Thank you for the answer Earl but I didn’t manage to do what yo
suggested me.
Could you write the macro for doing what I need? I would like to numbe
(progressive number) and print all pages contained in several sheet
preserving the setting print already made.
I attach a file with 3 sheets and 5 pages to print (setting print are
is already made). Could you write the macro for printing these 5 page
with progressive without changing the setting print area?
Thank in advance for your hel

Attachment filename: prova.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53979
--
Message posted from http://www.ExcelForum.com