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 tab>view code>copy/paste this>SAVE
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
[email protected]
"RobRoy" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>
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 <[email protected]>
> 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 tab>view code>copy/paste this>SAVE
> 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
> [email protected]
> "RobRoy" <[email protected]> wrote in message
> news:[email protected]...
> > 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
[email protected]
"RobRoy" <[email protected]> wrote in message
news:[email protected]...
> Thanks Don.
>
> How would I make the row hidden by entering data in a specific cell.
>
> Roy
>
> "Don Guillett" wrote:
>
> > right click sheet tab>view code>copy/paste this>SAVE
> > 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
> > [email protected]
> > "RobRoy" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> [email protected]
> "RobRoy" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks Don.
> >
> > How would I make the row hidden by entering data in a specific cell.
> >
> > Roy
> >
> > "Don Guillett" wrote:
> >
> > > right click sheet tab>view code>copy/paste this>SAVE
> > > 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
> > > [email protected]
> > > "RobRoy" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
[email protected]
"RobRoy" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "RobRoy" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks Don.
> > >
> > > How would I make the row hidden by entering data in a specific cell.
> > >
> > > Roy
> > >
> > > "Don Guillett" wrote:
> > >
> > > > right click sheet tab>view code>copy/paste this>SAVE
> > > > 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
> > > > [email protected]
> > > > "RobRoy" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I wish to be able to automatically hide a row when data is entered
> > into a
> > > > > cell in that row.
> > > > > Any ideas?
> > > > >
> > > > > Roy
> > > >
> > > >
> > > >
> >
> >
> >