Print specified worksheets in workbook

**chriswrcg** · 03-17-2018, 11:34 AM

I am currently using the following code to print a range of worksheets within my workbook. I was wondering however if I can add two printing stipulations to the code?

Please Login or Register  to view this content.

First, is it possible to add a line of code that will tell excel to print the sheets in color instead of black and white?

and secondly I was wondering how to add a line of code that will restrict printing to only those sheets that have active data on them. In other words excel should look to a cell on each page and if that cell has data then the page should be printed. if that cell is empty then excel should not print that worksheet and should move the the next one.
It would also be nice to be able to spectify a limit on the data to allow printing. if the percentage in the cell being looked at is 99% or lower then the page should be printed but if it is 100% or higher then the page should not print.

**AlphaFrog** · 03-17-2018, 01:54 PM

There are two settings to consider if you want to print in color.

There is the Printer Driver color settings. Excel does not have much control for that setting. You have to go into your Windows Control Panel and change the printer driver settings.
There is a setting within Excel that allows you to convert the printed sheet to a B&W document and then Print the sheet regardless if you have a color printer or not. So you can force a color printer to print in B&W by sending it only a B&W document. But you can't, from Excel, force a printer who's driver is set to print in B&W to print a color document. The B&W document setting in Excel is usually off by default. The code below makes sure that the Excel B&W setting is off just in case. But it won't guarantee that the Printer Driver is set to print in color. I don't know of a way to do that with code.

The code also checks on each sheet before printing that cell A1 is not empty and it has a value <= 0.99

Please Login or Register  to view this content.

Print specified worksheets in workbook

LinkBack

Thread Tools

Rate This Thread

Display

Print specified worksheets in workbook

Re: Print specified worksheets in workbook

Thread Information

Users Browsing this Thread

Similar Threads

Use Excel Print Button to print all worksheets in workbook and then ungroup

I want to print two worksheets from the same workbook as two pages of the same document.

[SOLVED] Only Print specific worksheets in workbook

Print specific worksheets in workbook

Print worksheets Workbook

[SOLVED] Can I print a list of all of the worksheets within a workbook?

[SOLVED] How do I print only the hidden worksheets in a workbook?

Bookmarks

Bookmarks

Posting Permissions