Hide Rows that are below a button (and be able to toggle)

Hi all,

I am having trouble coming up with code that allows me to create buttons that toggles between hide/unhidden rows, relative to where the button is.

Basically, i am trying to make it 2 buttons side by side, where button 1 will hide/unhide rows 2-6 below the button when clicked, button 2 will hide/unhide rows 7-11 below the button when clicked.

Does anyone have experience with this sort of thing?

Thanks

The code to go behind your Toggle buttons should be like this:

Please Login or Register  to view this content.

Thanks for the help. It works great, but I was hoping to make the buttons a relative reference, so instead of hiding/unhiding rows 2-6, I want to hide the rows that are 2-6 rows below button... so if the button is on row 1, the toggle button would hide rows 2-6, but if the button is on row 11, it would hide rows 12-16, etc.

From what I can tell the TopLeftCell property may be of help, but I don't know how to replace the range Rows("2:6") using that property.

Okay, with some help from Nilem on another thread I think we can now get you squared away. In the code below, from HideUnderButtons we call SelectShape and pass it the number (1,2, etc, depending on which button you want as your base). SelectShape selects the topleftcell the button is touching, and the rest of our code does the hiding and unhiding.

Please Login or Register  to view this content.

Let me know if more help is needed.

Hi, Thanks very much! Seems to get the job done so far.

I am thinking I will need to expand this a little. Here is my understanding, I am still just learning so hopefully all this makes sense..

Let's say I have 6 buttons lined up side by side, and each button hides different rows (button1 hides rows 2-6, button2 hides rows 8-12, button3 hides rows 14-18, button 4 hides rows 20-24, button5 hides rows 26-30, button65 hides rows 32-36)... and then I will repeat these 6 buttons several times throughout the sheet, as in the 6 buttons will do the same thing again starting on row 40... As of right now, all I have to do is use that code, make 6 copies (SubHideUnderButtons x 6) and just change the SelectShape (1) to SelectShape (2), (3), (4), (5), (6), but when I start again on row 40 for the 2nd batch of the 6 buttons I have copy the code and make 6 new Sub HideUnderButtons(7-13), and this will go on and on because I will end up with ~40 of these batches... this ends up being lots of code, not hard to do because I am just copy and pasting, but other people may want to use this in the future so I am trying to make this as simple as possible.

so my question is, is there a way to make the button that is clicked the activeshape, such that button1, no matter where it is or how many copies I make of it, (row 1 or row 40), will always hide offset rows 2-6, whether it is row 2-6 or rows 42-46.

Thanks again for your help so far!

I think I got it working perfectly now. here is what I did.

Please Login or Register  to view this content.

and now I can just copy and paste my 6 buttons further down the sheet, and it will work for those too!

thanks for all the help

Glad to know it helped. If this fixes your issue please don't forget to mark your thread "Solved".