Hiding Rows based on cell value and macro kicked off with a button.

[malemke78]

We're working on a macro to hide certain rows based on a cell's value (true, false). The idea is they select the checkboxes (in column A) next to the spec sections we want to keep in the excel file. Any checkboxes that are not selected, we would want to disappear. Each checkbox is linked to its own cell with a checked = true link.
There are checkboxes in row lines 41 to 714, but there are breaks for the Division titles.
Ideally, we would like to tie this macro to button 2304 (name pending).

Is this possible? Open to suggestions. Thanks so much!

 

[Jamie McMillan]

Hello,

This should do the trick, assign it to a button at the end. It will hide all the False rows. (There is also one to UnHide the rows; if you want that. )

Sub HideThem()
Dim i As Integer
i = 1
    For i = 41 To 714
    If Cells(i, 1).Value = False Then
    Cells(i, 1).EntireRow.Hidden = True 'hides all the rows with a 0 in column A
    End If
Next i
End Sub
Sub UnHideThem()
    Cells.EntireRow.Hidden = False 'unhides all the rows
End Sub

Jamie

 

[malemke78]

Hello,

This should do the trick, assign it to a button at the end. It will hide all the False rows. (There is also one to UnHide the rows; if you want that. )

Sub HideThem()
Dim i As Integer
i = 1
    For i = 41 To 714
    If Cells(i, 1).Value = False Then
    Cells(i, 1).EntireRow.Hidden = True 'hides all the rows with a 0 in column A
    End If
Next i
End Sub
Sub UnHideThem()
    Cells.EntireRow.Hidden = False 'unhides all the rows
End Sub

Jamie

Jamie!
Thanks. The only issue is the checkboxes remain behind and pile up. Is there a way to have them disappear with their corresponding row?

 

[Jamie McMillan]

Hello,

You need to set the textboxes - 'to move and size with cells'

For some reason it was disabled on mine, so:-

You select the textboxes. Go to the format tab and click the little 'more arrow'. Have a look at the image

Then they hide with the rows.

Jamie

 

[malemke78]

Hello,

You need to set the textboxes - 'to move and size with cells'

For some reason it was disabled on mine, so:-

You select the textboxes. Go to the format tab and click the little 'more arrow'. Have a look at the image

Then they hide with the rows.

Jamie

thank you so much for the help!!

 

[malemke78]

Hello,

You need to set the textboxes - 'to move and size with cells'

For some reason it was disabled on mine, so:-

You select the textboxes. Go to the format tab and click the little 'more arrow'. Have a look at the image

Then they hide with the rows.

Jamie

The option is disable on my checkboxes too.

 

[malemke78]

TY