Hide or unhide column or columns based on checkboxes/s

You'll get more responses if you attach a workbook so we don't have to try to recreate your scenario from a description ...

You did not say if you are using Form controls or ActiveX controls.
See the good advice of MatixMan.
To give you a start this code hides column C and D with ActiveX checkbox.

Please Login or Register  to view this content.

Put this in the worksheet module of the Data sheet and move the checkboxes in col G so they are fully in col G (they overlap into Col F unlike those in col B that are properly aligned in col B).

Please Login or Register  to view this content.

Solution is in the attached file. MM.

Does it work in the file i sent you?

Here the demo file that you have attached does the job as expected.

But in my real workbook which has a lot of data and worksheets,I made the checkboxes through developer tab>active X and pasted your code in the specific worksheet as said above by u ,then it does not work,perhaps link could not be established between all 8 checkboxes with the code.
Kindly guide with the series of steps.

There were / are a few issues.

1. you didn't assign the macro to any of the checkboxes - this is now done in the attached file.
2. you had full stops after some of the values - e.g. "Pure." instead of "Pure"
3. you have two values in the same column ... I don't know what is supposed to happen with those, but the Find function won't find a hidden cell so if a column is hidden because a checkbox is unchecked and then another is checked but the column is hidden, it will stay hidden. Perhaps it's just test data?

Hope that helps. MM.

You're welcome & thanks or the reps

You added checkboxes in the first column and the code is finding the label in the column to the left, which is causing the error. The If statement below stops the code if the checkbox is either in the first column or below row 4.

Please Login or Register  to view this content.