setting print

[pippo100]

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

 

[Earl Kiosterud]

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.

 

[pippo100]

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