Excluding formatting from print output

**JohnnyCash** · 02-15-2010, 05:40 AM

Hi Everyone

Can anyone advise how i can shade cells (to prompt completion) but when printing, exclude shading from the printed document?

Thanks very much
regards
John

**JeanRage** · 02-15-2010, 06:03 AM

Hi,

There are several solutions ...
Guess the simplest is for you to design a print macro, which before printing will remove shading from cells ...
To create and test your macro, turn on the macro recorder and perform the whole sequence once ...

HTH

**JohnnyCash** · 02-15-2010, 06:22 AM

Hi JeanRage

Thanks for you reply. I'm not an excel wizard by any stretch (LOL), but i presume what you are saying is set up a macro which removes the shading on the spreadsheet (and record it), before recording the actual process you go through to print the document. Would that apply to all worksheets in a spreadsheet?

Thanks
John

**JohnnyCash** · 02-15-2010, 06:23 AM

Hi JeanRage

Thanks for you reply. I'm not an excel wizard by any stretch (LOL), but i presume what you are saying is set up a macro which removes the shading on the spreadsheet (and record it), before recording the actual process you go through to print the document. Would that apply to all worksheets in a spreadsheet?

Thanks
John

**JeanRage** · 02-15-2010, 10:29 AM

Hi,

Once your work is done
1. Save your workbook
2. Use the following macro, before your print ...

Sub RemoveShading()
ActiveSheet.Cells.Interior.ColorIndex = xlNone
End Sub

3. Quit without saving in order to keep your cells shaded

HTH

**martindwilson** · 02-16-2010, 04:01 PM

just go file /page set up/sheet tab /select black and white
interior colours will not print and font will be black

**JohnnyCash** · 02-18-2010, 07:59 AM

Excellent! Thanks very much martindwilson

**teylyn** · 02-18-2010, 08:04 AM

Supporting Martin's solution, I think the challenge would be to restore the cell shading after the macro has removed it. Taking it away is easy. Getting it back would be harder, and I assume you'd want the user to see the cell colors after a print, no?