Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Programmatic Hiding
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] |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Programmatic Hiding
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 " wrote: 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] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding | Excel Discussion (Misc queries) | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
HIDING DIV/0! | Excel Discussion (Misc queries) | |||
#DIV/0! hiding | Excel Discussion (Misc queries) | |||
Hiding #N/A | Excel Worksheet Functions |