Hi,
It's the first time I've posted on here but I've spent the day pondering over how to do this. I'm certainly not a programmer (another accountant) so please bear with me with my explanation - I hope it makes sense!
I want to add a check box (activex) to a worksheet (named Control) and on clicking it it will hide columns B and C in two other seperate worksheets (names Week and Month). I've managed to get it to work on 1 worksheet providing I also put the checkbox on that sheet using the code below:
Private Sub CheckBox1_Click ()
If CheckBox1.Value = False Then
Columns("B:C"). Hidden = True
Else
Columns("B:C"). Hidden = False
End If
End Sub
But for the life of me I can't work out how to get it to work on other, multiple sheets.
I'd really appreciate your help.
Thank you.
It's the first time I've posted on here but I've spent the day pondering over how to do this. I'm certainly not a programmer (another accountant) so please bear with me with my explanation - I hope it makes sense!
I want to add a check box (activex) to a worksheet (named Control) and on clicking it it will hide columns B and C in two other seperate worksheets (names Week and Month). I've managed to get it to work on 1 worksheet providing I also put the checkbox on that sheet using the code below:
Private Sub CheckBox1_Click ()
If CheckBox1.Value = False Then
Columns("B:C"). Hidden = True
Else
Columns("B:C"). Hidden = False
End If
End Sub
But for the life of me I can't work out how to get it to work on other, multiple sheets.
I'd really appreciate your help.
Thank you.