Can I also add into the macro something that will make an option button true
when the checkbox is true, and vice versa?

"Toppers" wrote:

I placed a checkbox from the FORMS toobar on a worksheet with C1 as a linked
cell: this shows TRUE/FALSE. It called the following macro in a general
module which hid/unhid columns OK.

Sub Macro1()
Columns("C:F").EntireColumn.Hidden = Range("C1")
End Sub


Does this help?

"Min" wrote:

I'm stilll really struggling with my checkboxes!
How do I write a macro that will show columns on a worksheet when the box is
selected, and hide the columns again when it is deselected?
Many thanks to Dave who has already tried to help, but I need simple
instructions!