Programmatic Hiding

  • Thread starter Thread starter vjp2.at
  • Start date Start date
V

vjp2.at

How do I hide a row if a certain column has a zero in it?

I'm not really ready to do VB or macros and I'm not sure
the competitors overseeing this scoring system are ready to
accept anything too fancy.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]
 
Hi

I don't know how to do it without a macro but here's one to try. Right click
the sheet tab, view code and paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Address = "$A$1" Then 'change to suit
If Target.Value = 0 Then
Rows("9:9").Hidden = True 'change to suit
Else
Rows("9:9").Hidden = False 'change to suit
End If
End If
End Sub

If a zero is enter in A1 then row 9 becomes hidden, anything else the row
becomes visible

Mike
 
If you don't want coding, you may?? want to do this with conditional
formatting. Select the row header (left side)> Format>conditional
format>formula is =if(countif(2:2,0)>0>format font as white(same color as
background) to hide the font on the entire row if any cell on the row has a
0. Of course, the problem is how to now find which has the 0 . Or, as you
said, "a certain column" so formula would be =$a$2=0
 
Back
Top