Code for Hiding / unhiding columns using Active X Control Checkbox

[davidfrommke]

Hello all -

I am in need of assistance.
What I am trying to do is create a code where I click on a checkbox using an Active X Control Checkbox and it only displays information in that column.
For example, if my spreadsheet has "GM", I click the check box and the only column that appears is "GM" and all the others are hidden.

The problem I am having is when the checkbox is not checked, it shows that particular column.

Here is the code I am using -

Private Sub CheckBox2_Click()
    [k:bc].EntireColumn.Hidden = Not CheckBox2
End Sub

I know it is something simple, which means I cannot recall what it is.

And as long as I have you, what would the code be in this situation.

I want to only show one column. But I need the columns before a particular column and after to be hidden.

Thanks in advance for your assistance.

Dave

Also asked here Active X Control Checkbox to hide columns when checked