Print Workbook Macro

Hello,

I'm creating a macro that will set the print areas on my workbook automatically and open up the print dialog box. I've attached a copy of the spreadsheet that I'm working on.

I only want to print the yellow area in Sheet1, Sheet2 and Sheet3. I don't want to print Sheet 4.

I've created a copy of the macro that I'm working on. Any help on how I can get it to work would be appreciated.

Please Login or Register  to view this content.

Thanks

PrintWorkbook.xlsx

Hi,

See if this is what you are after...click the button on Sheet1.

Hope this helps

@JBeaucaire: I didn't think that displayed the dialog...?

The method I used selects all the sheets required as an array after the page setup macros, then autoselects the "Selection" option under "Print What", so that only the selected worksheets are printed

Originally Posted by ajryan88

@JBeaucaire: I didn't think that displayed the dialog...?

The method I used selects all the sheets required as an array after the page setup macros, then autoselects the "Selection" option under "Print What", so that only the selected worksheets are printed

Thank you so much ajryan88.

The only problem I'm having is that it only prints the selected cells A1 in Sheet1, Sheet2 and Sheet3.

If I change my preference to "Entire Workbook" in the Print Dialog box, it then prints all the Sheets (I don't want to print Sheet4).

Originally Posted by ajryan88

Sorry, my mistake. In my code, remove the Arg12:=True. This should then select Active Sheet(s) by default.

Hopefully this works for you

Thanks ajryan88. That did the trick.

Glad to hear it!

Have a great day