Show/Hide Button

[sdbrown81]

Im creating a dictionary in Exel and would like a show hide button. At the moment it works fine but my cells are static. I have a row titled B on row 7, and C on row 12. If I add a row in between then obviously the button wont work properly. How do I adjust the code below to say "show or hide all rows between "B" and "C"

Private Sub CommandButton2_Click()
Dim myRng As Range

Set myRng = Me.Range("b8:b11")

myRng.EntireRow.Hidden = Not (myRng(1).EntireRow.Hidden)
End Sub

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[sdbrown81]

Sorry! this my first post

Please Login or Register  to view this content.

[john55]

hi,
not sure if it helps you but just try it!

Please Login or Register  to view this content.

[sdbrown81]

Thanks John

This one didnt work though

[john55]

ah...sorry! I misunderstood!

[snb]

Please Login or Register  to view this content.

[sdbrown81]

Hi snb
That one still only hides the selected cells. I need to it search for the cells containing B and C, and hide everything in between

[snb]

It's rather confusing to use B and C for rows.

Please Login or Register  to view this content.

Why don't you post a sample workbook to illustrate your question ?

[sdbrown81]

Attached is sample. As you can see, the button works now, but if you add a line between B and C, then it doesnt work anymore.

[snb]

If you empty the cells in which the commandbuttons reside this will suffice:

Please Login or Register  to view this content.

[sdbrown81]

Thanks very much you are a star!