VBA - Print Worksheets Based on Cell Value

**thesonofdarwin** · 05-18-2012, 01:18 PM

I have a workbook where I want it to print worksheets based on cell value. I always want the main worksheet (called Template) to print. I also want the worksheet associated with the value in cell A1:J1 (merged cell) to print. I thought I had the code right, or pretty close, but it doesn't seem to be working.

Please Login or Register  to view this content.

Is there something I'm missing here? Also, I want the Print Options pop-up box to appear as we sometimes need to change things there.

**JBeaucaire** · 05-18-2012, 01:40 PM

This should be all you need to print:

Please Login or Register  to view this content.

**thesonofdarwin** · 05-18-2012, 01:57 PM

That's not working either. Is it missing the command to print after it selects the worksheets?

**Pulsus** · 05-18-2012, 03:07 PM

thesonofdarwin,

Try this:

Please Login or Register  to view this content.

**JBeaucaire** · 05-18-2012, 05:03 PM

you said you wanted to printout but have the print dialog open. My macro does that... it selects the two sheets and opens the print dialog.

Please Login or Register  to view this content.

If all you want is for it to print the sheets for you, just change that to:

Please Login or Register  to view this content.

**thesonofdarwin** · 05-19-2012, 02:50 PM

Alright, that works if I activate it as a Macro. I know there is a way to activate this automatically just by hitting hitting print as I've accomplished it previously, but I cannot find my code.

I'm sorry, I was not clear about my goal. I want the user to be able to click Print (Quick Print or File->Print) and for this to work.

**JBeaucaire** · 05-19-2012, 02:59 PM

You can try putting that into a Workbook_BeforePrint event macro in the ThisWorkbook module, but I wouldn't recommend that. Since the default hotkey for printing is CTRL-P, for this workbook I would install the macro as shown, then assign the CTRL-P hotkey to that macro. Then you can still access the normal print dialog using the FILE > PRINT method.