Toggle Button to Hide Rows

[tryingtoexcelatexcel]

Hi All,

I'm using the following code for toggle buttons to hide rows. The first button seems to work fine I can hide and unhide easily. But when I try to add another button it won't let me hide or unhide unless I use the ToggleButton1 first.

The second button seems to be dependent on the first. Is there anyway to make these buttons independent because I will need up to 6 buttons.

5 of them will be for specific parts of the worksheet to hide/unhide and the last one will be to unhide all.

Thank you very much in advance.

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Should the line highlighted in red say ToggleButton2?

Please Login or Register  to view this content.

BSB

[tryingtoexcelatexcel]

Ah.. thank you very much. Very careless of me.