Automatically hide column or row if a cell value meets criteria
 

I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell.

For instance, =IF(D2="",*****,D2)

with ***** being the formula

or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3)

of course this isn't working but something like this would be great

Thanks so much for your continued assistance.

Don

Automatically hide column or row if a cell value meets criteria
 

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("C3")
If .Value = 0 Then
.EntireRow.Hidden = True
Else
.EntireRow.Hidden = False
End If
End With
stoppit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP


On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote:

I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell.

For instance, =IF(D2="",*****,D2)

with ***** being the formula

or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3)

of course this isn't working but something like this would be great

Thanks so much for your continued assistance.

Don

Automatically hide column or row if a cell value meets criteri
 

I am having a similiar problem. I wanted to hide a row everytime a task is
complete. For example, anytime in colum F shows status complete I want to
hide row.

1. What would be the best macro for this function?
2. How do I add a macro to excel?

Thanks in advance!

"Gord Dibben" wrote:

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("C3")
If .Value = 0 Then
.EntireRow.Hidden = True
Else
.EntireRow.Hidden = False
End If
End With
stoppit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP


On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote:

I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell.

For instance, =IF(D2="",*****,D2)

with ***** being the formula

or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3)

of course this isn't working but something like this would be great

Thanks so much for your continued assistance.

Don

Automatically hide column or row if a cell value meets criteri
 

How would the "status complete" get entered into column F?

If manually just use this code

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 6 And _
Target.Value = "complete" Then
Target.EntireRow.Hidden = True
End If
enditall:
Application.EnableEvents = True
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code".

Copy/paste into that sheet module.

Edit to suit then Alt + q to return to the Excel sheet.

Enter "complete"(no quotes) in F1 and see row1 disappear(hide).


Gord

On Tue, 10 Jun 2008 12:10:00 -0700, Mindy
wrote:

I am having a similiar problem. I wanted to hide a row everytime a task is
complete. For example, anytime in colum F shows status complete I want to
hide row.

1. What would be the best macro for this function?
2. How do I add a macro to excel?

Thanks in advance!

"Gord Dibben" wrote:

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("C3")
If .Value = 0 Then
.EntireRow.Hidden = True
Else
.EntireRow.Hidden = False
End If
End With
stoppit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP


On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote:

I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell.

For instance, =IF(D2="",*****,D2)

with ***** being the formula

or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3)

of course this isn't working but something like this would be great

Thanks so much for your continued assistance.

Don