Removing Print Area

D

dwadholm

Is there a way to totally remove the print area from a worksheet?

I have a financial spreadsheet that people download from the internet and I
want to simplify the printing process by "tagging" selected worksheets to
print and others not to print.

Note: I wish for this to happen automatically...i.e. - without the user
having to input page numbers in the print dialog or "Ctrl + selecting
worksheets".

Can anyone help?

dwadholm
 
D

Don Guillett

Sub printsheets()
Sheets("sheet1").Range("a2:c5").Printout 'Preview
Sheets("sheet2").Range("a4:d15").Printout 'Preview
'etc
End Sub
 
D

dwadholm

Thanks...but I am only formula saavy not tech/programming saavy. Where do I
place the code you provided/

dwadholm
 
Top