How do I automatically hide rows
 

I wish to be able to automatically hide a row when data is entered into a
cell in that row.
Any ideas?

Roy

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the row hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered into a
cell in that row.
Any ideas?

Roy

Roy

This would require worksheet event code.

Several options to consider......

Any cell in any row?
A specific cell in any row?
Any cell in a specific row?
A specific cell in a specific row?

Row(s) to remain hidden until you manually unhide?


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 08:39:04 -0800, RobRoy
wrote:

I wish to be able to automatically hide a row when data is entered into a
cell in that row.
Any ideas?

Roy

Gord,

It would be a specific cell in any row.

Roy

"Gord Dibben" wrote:

Roy

This would require worksheet event code.

Several options to consider......

Any cell in any row?
A specific cell in any row?
Any cell in a specific row?
A specific cell in a specific row?

Row(s) to remain hidden until you manually unhide?


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 08:39:04 -0800, RobRoy
wrote:

I wish to be able to automatically hide a row when data is entered into a
cell in that row.
Any ideas?

Roy

Thanks Don.

How would I make the row hidden by entering data in a specific cell.

Roy

"Don Guillett" wrote:

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the row hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered into a
cell in that row.
Any ideas?

Roy

specific cell????? Do you mean a specific column within the row?? If so,
which one???

--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Thanks Don.

How would I make the row hidden by entering data in a specific cell.

Roy

"Don Guillett" wrote:

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the row
hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered
into a
cell in that row.
Any ideas?

Roy

Yes, for instance if I enter data into A2 then row 2 would br hidden but not
if I enter data into B2 etc.

"Don Guillett" wrote:

specific cell????? Do you mean a specific column within the row?? If so,
which one???

--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Thanks Don.

How would I make the row hidden by entering data in a specific cell.

Roy

"Don Guillett" wrote:

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the row
hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered
into a
cell in that row.
Any ideas?

Roy

Yes, for instance if I enter data into A2 then row 2 would br hidden
but not if I enter data into B2 etc.

I've used AutoFilter for this.

Select column A and use
Data Filter AutoFilter
This adds a pull-down arrow at A1 and lets you show rows with blanks in
column A (for example). After making a change in column A, click the pull-
down arrow again.

By the way, is there something as easy as this for columns rather than
rows? I saw a posting that suggested a macro, but I'd prefer something like
AutoFilter.

If you want for column B then modify my macro to
If Target.Row 4 and target.column=2 Then Rows(Target.Row).Hidden = True


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Yes, for instance if I enter data into A2 then row 2 would br hidden but
not
if I enter data into B2 etc.

"Don Guillett" wrote:

specific cell????? Do you mean a specific column within the row?? If so,
which one???

--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Thanks Don.

How would I make the row hidden by entering data in a specific cell.

Roy

"Don Guillett" wrote:

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the
row
hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered
into a
cell in that row.
Any ideas?

Roy