"Print all" macro for receipt generates new sheet for every reciept

[templeowls]

I have a spreadsheet that generates receipts for an auction. In the receipts spreadsheet, there is a button to print the current receipt and print all receipts. When "all" is selected, for some reason it generates a new sheet for every paddle #'s receipt.

Any idea how to correct this in the code?

[Logit]

.
Trying to understand what your final goal is.

Are you wanting to print the SILENT AUCTION sheet as a single document ?

[nigelog]

Take care with pressing "Print All" button on worksheet as there is no preview or selection of what is printed. I inadvertently pressed yesterday and had to run to turn off the main printer...

[templeowls]

No, the RECEIPTS sheet shows the receipts the for each respective paddle # (guest). You can change the paddle number via the dropdown menu. The "Print All" is needed so that we can quickly print all the receipts at the conclusion of the auction. The SILENT AUCTION is mainly for data entry for the winning bid and winning paddle number.

But for some reason, the PRINT ALL button creates a new sheet for every receipt, which is not needed. It does not do this when PRINT SINGLERECEIPT is selected, which only confuses me further.

[Logit]

.

You can change the paddle number via the dropdown menu.

The copy of the workbook you posted does not include a drop down .. unless I simply overlooked it.

Re: the difference between the SINGLE RECEIPT and PRINT ALL selections .... I don't understand your confusion. ???? The macros are doing
exactly what the title on the buttons indicate.

Again, if you click the PRINT ALL button, what result are you expecting ?

[Mumps1]

Please check this link: https://www.excelforum.com/excel-pro...readsheet.html

[templeowls]

It you press on B7 on the RECEIPTS sheet, there will be a dropdown button that will let you select any paddle #

My issue is that the PRINT ALL option creates new sheets for every receipt. I do not want this; I merely want it to print out the receipts. The SINGLERECEIPT does not do this. It just prints out the selected paddle number's receipt. It does not create a new sheet in addition to printing.

[Mumps1]

Did you try the file I attached in your original post at: https://www.excelforum.com/excel-pro...readsheet.html

[templeowls]

Perfect!! Solved!!