Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions | |||
AUTO HIDE ROWS | Excel Worksheet Functions | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |