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