Hide Co9lumns based on cell value
Hi Gary,
Am Mon, 21 Jan 2013 02:46:05 +0000 schrieb garygoodguy:
I have some vba to hide some columns in one sheet based on a cell value
in another sheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Sheets("Start").Range("U4").Value = "OFF" Then
Columns("P:AB").EntireColumn.Hidden = True
Else
Columns("P:AB").EntireColumn.Hidden = False
End If
End Sub
in which sheet (name) you want to hide the columns?
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|