Hide Co9lumns based on cell value
Gary,
Place this code in the ThisWorkbook module and change "MySheet" to the sheet you wish to hide columns on.
Ben
Private Sub Workbook_Open()
Sheets("MySheet").Columns("P:AB").EntireColumn.Hid den = _
(Sheets("Start").Range("U4").Value = "OFF")
End Sub
|