Do not Print Selected Cell Values

  • Thread starter Thread starter JMay
  • Start date Start date
J

JMay

My current Print Range is A1:G40.
I have several cells with number input, some with formulas in them. In
either
case how can I disable them (cells G20, B32, etc) from printing. My
printed page should show these cells as if they were blanks. How?
TIA,
 
I looked at the format/cell/protection/hidden option, but
that didn't seem to work, so this solution is brute force.

Make a macro to change the font color to white, print the
data and return the font color to normal. Like this...

Sub printHidden()
Range("G20,B32").Select 'Add what ever cells here
Selection.Font.ColorIndex = 2 'whatever is white
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Selection.Font.ColorIndex = 0 'Color back to normal
End Sub
 
One way would be to set up a separate Sheet just for printing, and link all
the cells from your Sheet1 to this PrintSheet, "except" for the ones you
don't want to print...........then just print out the PrintSheet.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top