printing multiple worksheets in excel in colour

A

arankine

New Member
Joined
Sep 9, 2009
Messages
1
hello there,

I have an issue when printing multiple excel worksheets in colour. I'm using Excel 2003.


The default driver setting for our printer is set to Black & White although it can do both colour and B & W. When trying to print multiple worksheets in a workbook if you go to the printer properties and change the setting to colour only the first sheet prints in colour the rest comes out as B&W.

It appears that the only method for printing all worksheets in colour is to select each worksheet individually and change its properties to colour. This is quite frustrating if you have a large workbook.

I have tried different print setting and worksheet options of selecting all worksheets together and grouping them or using the 'entire workbook' button.

Any advice or possibly scripts to overcome this would be appreciated.

thanks
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
I wonder if you can set up an "additional" printer in Windows (with another name pointing to the same printer) and set up so it will only print colour as default.
 
Upvote 0
arankine said:
hello there,

I have an issue when printing multiple excel worksheets in colour. I'm using Excel 2003.


The default driver setting for our printer is set to Black & White although it can do both colour and B & W. When trying to print multiple worksheets in a workbook if you go to the printer properties and change the setting to colour only the first sheet prints in colour the rest comes out as B&W.

It appears that the only method for printing all worksheets in colour is to select each worksheet individually and change its properties to colour. This is quite frustrating if you have a large workbook.

I have tried different print setting and worksheet options of selecting all worksheets together and grouping them or using the 'entire workbook' button.

Any advice or possibly scripts to overcome this would be appreciated.

thanks
Click to expand...

welcome to the forum

this is not really an excel issue

goto printers in windows control panel

change the default color setting there before you select any thing to print.
 
Upvote 0
wsjackman said:
welcome to the forum

this is not really an excel issue

goto printers in windows control panel

change the default color setting there before you select any thing to print.
Click to expand...

Good day

Unfortunately, this is an Excel issue. I am using Excel 2007 and 2010 and I am having the same issue. I have tested this on multiple printers, ranging from an HP M521 MFP, Xerox C75, DC252, WC5687, WC7835, WC 7845, ColorQube and Konica Minolta C652, C451 and Kyocera C3550ci With no luck.

I have also read up on the Microsoft Website and a LOT of people have complained about this perticular issue. Yet, Microsoft have done nothing about it. I have read up on another forum to setup and use Macros. Similar to this:

'Prints every sheet
Dim ws as Worksheet
Sub PrintMe()
For Each ws in ActiveWorkbook.Worksheets
ws.PrintOut
Next ws
End Sub


So I am gonna give this a shot.
 
Upvote 0
I appear to have fixed the "follow me" printer driver issue with Excel.

1. Ctrl P
2. Select your color printer
3. Under settings, select Print entire workbook
4. In your preview, click the right arrow until you reach your first B&W page
5. Under settings at the very bottom, click on Page Setup
6. When the box comes up, click on Options
7. When the next box comes up, click on Color Options
8. Click on either Automatic Color or Vivid Color - then click on OK
9. The previous box will come up so click OK on that too

Hey Presto...it's fixed. It doesn't seem to work if you access Page Setup anywhere else. Go figure.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA to change cell colour based on content
Replies
3
Views
154
Snakehips
Snakehips
D
  • Question
Very weird print margin problem, need help !
Replies
0
Views
132
dicklim39
D
C
  • Question
Problems Printing Multiple Tabs with One Tab upside down and Backwards
Replies
5
Views
94
mdmilner
M
G
  • Solved
Print resultValue from VBA script
Replies
5
Views
418
georgeeye
G
C
  • Question
Multiple Workbooks to one.
2
Replies
11
Views
520
dmt32
D

Forum statistics

Threads
1,214,653
Messages
6,120,755
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top