Button to hide and unhide rows

[singingsister]

Hi guys,

I used to know how to do this but have forgotten!

I want to have a toggle button to hide and unhide a selection of rows (in this case F-P).

I've remembered how to record a macro and create a button but this only hides the rows. I want to be able to click the same button again to unhide the rows.

Can you advise me how?

Sarah

PS - Excel 2010

 

[Andrew Poulsom]

An example:

Private Sub ToggleButton1_Click()
    Rows("6:10").Hidden = ToggleButton1.Value
End Sub

 

[singingsister]

An example:

Private Sub ToggleButton1_Click()
    Rows("6:10").Hidden = ToggleButton1.Value
End Sub

That's great!

Remind me where I have to put that and how to assign it to a button please!

 

[Andrew Poulsom]

Right click any Toolbar and click Control Toolbox. Click the Toggle Button icon and click and drag on your worksheet to position and size it. Right click the ToggleButton and choose View Code. Overwrite the procedure stub with the code I posted and press Alt+F11 to return to your worksheet. Click the button at top left of the Control Toolbox to exit Design Mode and click the ToggleButton to try it out.

 

[singingsister]

Right click any Toolbar and click Control Toolbox. Click the Toggle Button icon and click and drag on your worksheet to position and size it. Right click the ToggleButton and choose View Code. Overwrite the procedure stub with the code I posted and press Alt+F11 to return to your worksheet. Click the button at top left of the Control Toolbox to exit Design Mode and click the ToggleButton to try it out.

OK I'm really being thick. I'm clicking any toolbar and I don't see Control Toolbox. I'm using Excel 2010 and have added the "developer" toolbar to the ribbon

I know how to find the buttons under the developer toolbar but can't see one labelled toggle button?

 

[Andrew Poulsom]

On the Developer tab click Insert in the Controls group. In the ActiveX Controls group it's second from the right on the second row.