Hiding rows which have a check box

[MOB]

If I hide rows on my spreadsheet which have check boxes on them, the check boxes do not disappear, they appear to stack up behind each other

Is there a way to also hide these check boxes? I am using VBA to hide the rows so a VBA bit of code to hide the check boxes would be perfect!

TIA

 

[dmt32]

If I hide rows on my spreadsheet which have check boxes on them, the check boxes do not disappear, they appear to stack up behind each other

Is there a way to also hide these check boxes? I am using VBA to hide the rows so a VBA bit of code to hide the check boxes would be perfect!

TIA

Have a read of this article:https://www.extendoffice.com/documents/excel/3697-excel-hide-checkbox-with-row.html#a1

& see if any help to you

Dave

 

[MOB]

Thanks Dave

I also googled it and came across this bit of code which I'm going to use instead of the check boxes, double click produces a tick mark in the cell, will solve this and some other issues I was facing

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'tick cell when double click

    If Not Intersect(Target, Range("K12:T31")) Is Nothing Then
        Application.EnableEvents = False
        If ActiveCell.Value = ChrW(&H2713) Then
            ActiveCell.ClearContents
        Else
            ActiveCell.Value = ChrW(&H2713)
        End If
        Cancel = True
    End If
    Application.EnableEvents = True
End Sub

 

[dmt32]

Thanks Dave

I also googled it and came across this bit of code which I'm going to use instead of the check boxes, double click produces a tick mark in the cell, will solve this and some other issues I was facing

[/QUOTE]

Good solution 

Dave

 

[My Aswer Is This]

I also believe using Double click is a good plan versus a lot of Check Boxes

But I not sure what your plan here is.
In the code you showed it only enters a Check Mark or clears the Check Mark.
How do you plan to hide the row?

Your code shown here does not hide a row.
And how do you plan to Unhide the row?