Excel: don't print fill color 1

[cramz]

Using Excel 2003.

How do I make it so that fill colors do not print?

 

[PGoRule]

Just follow these steps:
File->Page Setup->Sheet Tag.
Check 'Black and white'
Say 'OK'.

This will not print Fill color cells, but all the text in your sheet will be printed as Black...So if you don't want to use text colors and print output in only Black then adopt this method.

Sharing the best from my side...

--Prashant--

 

[cramz]

I probably should have specified that some of the text needs to be in color; so telling it to print in only b&w won't solve my issue.

I thought there was something that explicitly referenced the non-printing of fill or background colors. Maybe that's access or something else.

Any more ideas?

 

[Fenrirshowl]

Cramz

Simplistic answer for you:

Set up all of your print areas and everything with your spreadsheet as is.

Select all of the cells, select no fill from the background color dropdown, print, and then undo the no fill action to regain the original.

It's only a couple of mouse clicks and probably easier than designing anything more technical.

Fen

 

[cramz]

Fen:
I had a similar idea. I like your outside the box thinking. The only problem is that I'm not going to be the one using it. It's something I'm creating for someone's biz. And I'm locking down much of the spreadsheet's functionality, including changing format.
What I was thinking was creating a VBA module that waits for a print event and then uncolors the cells. After the print is done, it would reinstate the colors. But I don't know...it's just an idea I was toying with.

 

[Fenrirshowl]

I don't know your VBA ability but if you are locking down the sheets (i.e. the print area will remain the same) you can record the macros to set print area, remove the fill, print, undo etc . Then you can add a "print" button to each sheet, assign the macro and lock it down. You will have an issue about sheet protection but this is easily resolved (again record the macro while you remove and reinstate it [if you don't know the code] and patch it into the first). Hopefully it will then all work out.

Fen

 

[cramz]

Thanks again Fen. I've been toying with VBA a little here and there. This worksheet is actually one in a set that work together to accomplish a common task.
-C