hiding data

[cgriff]

what a am trying to to do is hide a range of data
if a1=false hide b6:c23

Thanks in advance
This message was edited by cgriff on 2002-10-05 14:29

 

[Legacy 98055]

Hi
I'm not sure if you can hide a select range of data though you can hide formulas. You may, however, hide complete rows or columns.
This little procedure will hide columns B & C if the value in A1 is false and show the columns if the value in A1 is true.
Right-Click on your worksheet tab choose "view code", and paste the following as is:
<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Not TypeName([A1].Value) = "Boolean" Then _
Exit Sub Else: Columns("B:C").EntireColumn.Hidden = Not [A1].Value
End Sub

</pre>
Tom

 

[rikrak]

On 2002-10-05 14:02, cgriff wrote:
what a am trying to to do is hide a range of data
if a1=false hide b6:c23

Thanks in advance

Hello,

What about using conditional format?
1. Select the cells you wanna hide
2. from the menubar select Format|Conditional format
3. enter formula =A1=FALSE
4. select format: set textcolor to equal backgroundcolor

 

[Yogi Anand]

On 2002-10-05 14:02, cgriff wrote:
what a am trying to to do is hide a range of data
if a1=false hide b6:c23

Thanks in advance
This message was edited by cgriff on 2002-10-05 14:29

Hi cgriff:

I can't say if this is a viable option for you ... but

You can CUSTOM FORMAT the entries you intend to hide as ;;;

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-08 16:21