Hide/unhide rows with buttons

[tracktor]

I am using several toggle buttons to hide/show rows of data related to the specific toggle buttons. I also want to hide and show the toggle buttons as well. When I try to do that the data underneath the toggle buttons is hidden but the toggle buttons don't hide with the cells.

A solution for the problem that I am having would be to have the ability to click on a cell as if it were a toggle button and hide/show rows of data when clicked.

OR

If there is a way to hide/show buttons as well would work too.

Your help is greatly appreciated.

 

[Michaels]

Hi !

You can do that by recording a macro and making a textbox and assigning the macro to textbox and add the text you like in text box like Show/Hide.

Hope this helps.

 

[tracktor]

Thanks for the reply. I will try that now.

 

[tracktor]

No. That does not work. If I add any control button or text box when I try to hide that row the control stacks up over the unhidden rows. That is what I am trying to avoid.

Basically I want to "toggle" a cell to hide or unhide specific rows. And if I want to hide or unhide the cell with another toggle cell then it will hide as well.

 

[Michaels]

No. That does not work. If I add any control button or text box when I try to hide that row the control stacks up over the unhidden rows. That is what I am trying to avoid.

Basically I want to "toggle" a cell to hide or unhide specific rows. And if I want to hide or unhide the cell with another toggle cell then it will hide as well.

Hi !

You can try this:

1. Start recording the macro.
2. Select the rows (multiple rows by holding Ctrl + the specific rows' numbers).
3. The particular rows will be highlighted.
4. Release the Ctrl button.
5. Go to Home (if using Excel 2007), click format, Unhide and Hide, then click hide rows.
6. Since whatever you are doing, is being recorded behind the scenes in excel memory. Then stop recording the macro.
7. Create a textbox wherever you like. Add text if you want.
8. Right-click the textbox and then click Assign Macro and from the list choose the one you just recorded.

Now you are textbox is ready. Play with it if you like.

Hope this helps.

 

[Michaels]

Actually you can make two textboxes. One for Hide and one for Unhide. Do the same process for unhide (with macro).

Hope this helps.

 

[tracktor]

I cant use text boxes or any other control as the controls themselves can't be hidden. That is why I want to be able to select a cell to do the hiding and showing of rows.

 

[ZVI]

Select ToggleButton > Right Click > Format Control > Properties > Move and size with cells > Ok
Is it?

Or you mean: ToggleButton1.Visible = Not ToggleButton1.Visible ' True/False

 

[tracktor]

I have figured out how to write the code to hide and show rows but I have to use 2 different cells (A24,A25). I just want to use one cell to hide and/or show the rows.

Here is the code i wrote

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Cells.Count > 1 Then Exit Sub

        If Not Intersect(Target, Range("A25")) Is Nothing Then

                If Target = "" Then
                
                    Rows("25:30").Select
                    Selection.EntireRow.Hidden = True

                    Rows("24").Select
                    Selection.EntireRow.Hidden = False

                End If

        End If

        If Not Intersect(Target, Range("A24")) Is Nothing Then

                If Target = "" Then
                
                    Rows("25:30").Select
                    Selection.EntireRow.Hidden = False

                    Rows("24").Select
                    Selection.EntireRow.Hidden = True

                End If

        End If
End Sub

 

[tracktor]

The toggle buttons move and size with cells but they don't hide with cells. Once again... I can't use controls when hiding rows.