A Print code to choose the print page

[newqueen]

Dear All,

I have designed a report which spans two pages, and I have the vba code below to enable me and other users to print the two pages when the need arises.

I set up a print area for the two pages (combined) as follows: A12:P74 – [see print area in code below]:

Please Login or Register  to view this content.

The above code is intended to print both pages 1 and 2 of a report.

However, it is not all the time that a user might want to print all two pages of the report. There may be times when a user might wish to print –

Either (a) Page 1 only which goes from A12:P49

Or (b) Pages 1 and 2 – which is the entire defined print area of A12:P74

If it is possible, please, I would like to incorporate, in the code, a choice to be able to print either only page one or print both pages. I would be glad if the above code could be tweaked to help me to achieve that.

I should be grateful for your kind help with this.

Thanks.

Newqueen

[jolivanes]

Something like this maybe?

Please Login or Register  to view this content.

Or a small UserForm with radio buttons for a selection would look nicer.

BTW, why a "Do Not Print" Choice? Not using the print button will accomplish the same thing I would think.

[newqueen]

Thanks Jolivanes for your prompt and kind response. The code you provided solves the problem perfectly. I am truly very grateful to you for your kindness.

Meanwhile, it would be very nice to try your other options. My vba is at a very baby level. But if you can give me something to try on those options, I will be glad to do so, and might use one of those.

Again, thanks for your help.

Newqueen.

[jolivanes]

Play around with attached. Who knows, you might like it better.

[newqueen]

Thanks very much Jolivanes. I will try your attached file.

Again, you have been very wonderful.

Newqueen