Hide rows AND checkboxes in that row with code/macro

**Riqueza** · 08-23-2012, 05:11 AM

Hi, I am so not a developer and everything code related I have learned online from forums like this so I hope someone can help me with this!

Problem: I have a header row with a checkbox (CheckBox1) and if ticked then it should unhide rows 2 to 4 below and if unticked it should hide them again. The problem is that rows 2 to 4 all have a checkbox as well and when the rows get hidden the checkbox remains and I can't work out how to hide it too!

Code I am currently using to hide rows:

Sub HideUnhideCORE()

Rows("2:4").Select
If Selection.EntireRow.Hidden = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If
Range("$A$1").Select

End Sub

Can anyone help me amend this so it hides the checkboxes on row 2, 3 and 4 as well? Here's hoping! Thanks.

**arlu1201** · 08-23-2012, 05:23 AM

Are you using the activex checkboxes?

How about using the wingdings font to create a tick mark in your column instead of the checkbox? Then you will not face the problem of hiding the checkboxes.

If you check this thread - http://www.excelforum.com/july-compe...move-tick.html
It will show you how to double click and add/remove a tick mark.

**Riqueza** · 08-23-2012, 05:35 AM

Hmmm, that is quite good, however the double click I think will annoy my users. I think they would respond better to actual checkboxes.

I was using the Form CheckBox. Should I be using the ActiveX ones instead?

**arlu1201** · 08-23-2012, 05:38 AM

I was talking about the form checkboxes actually. Both active-x and form checkboxes are the same, just called differently.

If you do not want to double-click, you can just format the column to wingdings and then ask the user to type in "a". This will insert the checkbox.