|
|
Hiding rows
Thank you Chip
"Chip Pearson" wrote:
You can use and event procedure to do this (see
http://www.cpearson.com/excel/events.htm for more info about
events). Right click the sheet tab and choose View Code. In the
VBA code module that appears, paste the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then 'change cell as desired
If Target.Value 10 Then ' change criteria as desired
Target.EntireRow.Hidden = True
Else
Target.EntireRow.Hidden = False
End If
End If
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Davidjc52" wrote in
message
...
We would like to be able to enter a value in a cell and if it
meets our
predefined criteria the entire row would automatically hide. Is
this possible
in excel?
Thanks
|