Toggle Button Code

Hi

I am looking for a macro (as simple as possible) to attach to a toggle button.

What I want to happen when the button is clicked is:

Click Once:
1. Looks at range (say a1:a100) and where the cell value = "hide", it hides that row.
2. Changes the text on the button to Show

Click Twice
1. Unhides all rows in range A1:a100 where cell value = "hide"
2 Changes the text on the button to Hide


Thanks.

assuming the toggle button is called ToggleButton1

Please Login or Register  to view this content.

Exactly what I needed. Thank you.

Hi Stnkynts

One last question

If I wanted to put "hide" in to row 1 of columns A:AZ, how do I add that to the macro?

I would need the top half of the macro to also check the value of row 1 and if equal to "hide", then hide the column

And in the bottom half, the second click of the toggle button would unhide the columns also.

Thanks.