CommandButton Macro to print pages on another sheet based on cell contents

[Anarchus]

Hi,

Is there a macro for a commandbutton to print pages from another sheet based on the contents of cells?

If there is, I don't want the normal print box to appear, I'd like the button to automatically start printing the pages.


I have one sheet where I enter all the data manually. This is the page the commandbutton will be on, but the pages that will be printed are on a separate page.

The data is then transferred onto another sheet (that will be hidden from other staff) already set up to specific page size, layout and print area. Outside the print area will be cells containing the "print from", "print to" and "number of copies" numbers that the commandbutton will need to be linked to.

Hopefully this makes sense and is possible. I've attached a mock up of what I'd like.

Thanks
Adam

[morevijay1982]

check i have attached one file

please use the same and follow instruction

regards

cheers

[Anarchus]

Hi Morevijay,

That's brilliant! Had to configure the measurements but it appears to be working.

There's only one sheet that I want to print (Sheet2), this sheet would be hidden as no one will need to use it. All the data would be in another sheet (Sheet1) and on this page is where I want the button.

Is there a way so that when I click the button on Sheet1, only the pages from Sheet2 print?

Basically I want the exact set up as you have generously provided, I just want the actual print button for Sheet2 installed on Sheet1 instead.

[morevijay1982]

Check sheet 1

as excel restrcit that print or printpreview should be which sheet is you are viewing

as you can choose record for print by adding record no to cell dp4 and upto in cell dr4