macro help
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Columns("C:C").EntireColumn.Hidden = True Then
Exit Sub
Else
If Range("C1").Value = "hide" Then
Columns("C:C").Select
Selection.EntireColumn.Hidden = True
End If
End If
End Sub
"thaerr" wrote:
I know that I can create a macro that will monitor a specific cell, and once
that cell equals the contents of another cell, an event will occur. The event
that I would like to occur would be for the row to be hidden. I've worked
just a very little bit with macros, so I'm looking for help in creating this
macro.
|