On Tue, 22 Jan 2013 07:02:08 +0000, garygoodguy
wrote:



So I got this to work. Placed this code in workbook_open and just added
each sheet as necessary:


If Sheets("Start").Range("U4").Value = "OFF" Then
Sheets("MySheet").Columns("P:AB").EntireColumn.Hi dden = True
Else
Sheets("MySheet").Columns("P:AB").EntireColumn.Hi dden = False
End If

Thanks for the help.


I assume this would also work with rows?

I can make a version of this for my leap year handling, instead of
giving the user a pair of hide unhide buttons.

Not an expert - but don't see why it wouldn't also work with rows.