#1   Report Post  
Old September 29th 07, 09:57 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 10
Default 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   Report Post  
Old September 29th 07, 10:20 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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]

  #3   Report Post  
Old September 29th 07, 01:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default Programmatic Hiding


If you don't want coding, you may?? want to do this with conditional
formatting. Select the row header (left side) Formatconditional
formatformula is =if(countif(2:2,0)0format 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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding help with excel Excel Discussion (Misc queries) 1 March 9th 07 01:47 AM
Hiding a button when hiding rows fergusor Excel Discussion (Misc queries) 2 August 10th 06 02:31 PM
HIDING DIV/0! webster Excel Discussion (Misc queries) 2 March 10th 06 12:14 AM
#DIV/0! hiding GJR3599 Excel Discussion (Misc queries) 0 March 9th 05 07:54 PM
Hiding #N/A Mick Excel Worksheet Functions 4 December 1st 04 12:35 AM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017