Hello.

I am using a macro to hide a column. The macro works fine. In the column I have about 20 checkboxs. I would like the checkboxes to be hidden also when the column is hidden. Below is the macro I am using. Does anyone know what I can add to this macro to make the checkboxes hide.

I am new at this.. thank you...

John


Sub HideColsProjectCost()
Dim cl As Range
For Each cl In Sheets("Project Cost").Range("$AC$1")
If UCase(cl) = "1" Then
cl.EntireColumn.Hidden = True

Else: cl.EntireColumn.Hidden = False
End If
Next cl
End Sub