Removing Print Area

[Guest]

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

 

[Don Guillett]

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

 

[Guest]

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

dwadholm

 

[Don Guillett]

One way. Alt f11>copy/paste into the ThisWorkbook module>modify to suit>SAVE
the workbook. To execute assign to a button/shape or just use alt f8>this
workbook>run>
If you're new to macros, you may want to read David Ritchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gord Dibben]

I think Don meant to say this macro would be pasted into a general module, not
Thisworkbook module.

A great site for learning where to enter different types of code can be found at
Ron de Bruin's pages.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP

 

[Guest]

Thanks...I will check these out.

dwadholm

I think Don meant to say this macro would be pasted into a general module, not
Thisworkbook module.

A great site for learning where to enter different types of code can be found at
Ron de Bruin's pages.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP

 

[Don Guillett]

Gord,
Didn't want to confuse him if he didn't have or know how to create a general
module. Tested in the ThisWorkbook OK.

 

[Gord Dibben]

Thanks Don.

Gord