Hi Guys

I have on sheet1 a number (72 at the moment) of Form CheckBoxes.

In simple terms:
I would like a macro to look at each CheckBox and remember its state (Checked or Unchecked)

Then, go through and Check All checkboxes

Call MyMacro

Once MyMacro is complete (Filtering & Printing)

Revert the checkboxes to their original state.

The purpose of the checkboxes:

When Checked column on sheet2 is UnHidden
When UnChecked column on sheet2 is Hidden

Or,

UnHide All columns on sheet2, run MyMacro, then “re-hide” the columns that were previously hidden.

TIA
Keith