G
Guest
I have a workbook with 14 worksheets. Each worksheet has 6 checkboxes that
when true will show columns and when false will hide them again. The
checkboxes perform the same function on each worksheet. At the moment I have
the code on each sheet - exactly the same code 14 times over!
Is there any way of putting the code into just one place?
I tried doing it with macros but, although the columns would hide, they
wouldn't show again when the box was deselected.
Any help would be greatly appreciated, but my knowledge is very limited so
explanations need to be one step at a time!
Many thanks.
when true will show columns and when false will hide them again. The
checkboxes perform the same function on each worksheet. At the moment I have
the code on each sheet - exactly the same code 14 times over!
Is there any way of putting the code into just one place?
I tried doing it with macros but, although the columns would hide, they
wouldn't show again when the box was deselected.
Any help would be greatly appreciated, but my knowledge is very limited so
explanations need to be one step at a time!
Many thanks.