Hiding $ on a spreadsheet

T

TinaF

I want to hide all dollar amounts on a spreadsheet prior to printing.
It's an estimating spreadsheet and, for one purpose, I need to print
it out with only items and quantities showing - no dollar amounts.

Any way to hide cells that are formatted as dollars?
 
G

Gord Dibben

Tina

Sub gowhite()
Dim c As Range
For Each c In Selection
If c.NumberFormat = "#,##0.00" Then
c.Font.ColorIndex = 2
End If
Next
End Sub


Gord Dibben MS Excel MVP
 
Top