I created a form for my users to show or hide multiple columns at once but if they hide some columns and then later go back into the form the hidden columns are not checked. I tried to put this code behind the checkboxes and it still doesn't work:

[VBA]If Active.Range("A:A").EntireColumn.Hidden = True Then
ColumnA.Value = True
End If[/VBA]

active is a worksheet object set to the active workbookand columnA is the name of the checkbox