Forum Discussion

tmadaras485's avatar
tmadaras485
Copper Contributor
Mar 06, 2023

Hide/unhide Columns using checkbox

I want to hide/unhide a couple of columns with a checkbox.  Say columns K and L are the two columns I want to hide/unhide  - how would I go about doing that.
excel
Formulas and Functions
Macros and VBA
tmadaras485's avatar
tmadaras485
Copper Contributor
Mar 06, 2023
hide the columns when it is checked I want to unhide when it is checked.
HansVogelaar's avatar
HansVogelaar
MVP
Mar 06, 2023

tmadaras485 

That's easy:

Sub HideUnhide()
    Range("K1:L1").EntireColumn.Hidden = _
        (ActiveSheet.Shapes("Check Box 1").ControlFormat.Value <> 1)
End Sub

Resources