Using a control's name dynamically in a piece of code

[fynn]

Hey everyone,

I've currently got this code:

Please Login or Register  to view this content.

The CommandButtons hide the rows just underneath the button. As you can see, with only 5 buttons the code is already getting bigger. This will only get worse and the whole file will have hundres of buttons.

Is there a way to pass the name of the CommandButton clicked to the code so I don't need to duplicate the code for every new button?

Something like this semantic definition:

Please Login or Register  to view this content.

Any suggestions would be great!! Thanks.

[davesexcel]

Hi,
That's a lot of work maintaining hudreds of buttons,possibly one button would be required only.

Please Login or Register  to view this content.

and a global unhide code to reset the worksheet..

Please Login or Register  to view this content.

What kind of information do you want to extract?

[fynn]

I actually found a way to do it dynamically and quickly across all sheets, anywhere on the page:

Please Login or Register  to view this content.

I chopped it together from snippets on the web, works perfectly. Now I want to create a "hide all" button that will trigger, for example, the five buttons to the right of it.

[mikerickson]

You might want to switch to buttons from the Forms menu if you are going to have them all call the same routine. Forms buttons do not need to pass through a _Click event, they can call the routine directly.

Like Dave, I suggest that you use code to choose the cells to hide/unhide rather than running everything through buttons and their location.

[fynn]

Hi, Thanks for the reply.

All of the buttons are Form buttons not ActiveX controls. This means that I only have to give each button an individual name and it will work perfectly. So far I've copied the original set of 5 buttons about 6 times, and simply incrementing the number in the button's name makes it work.

Now all I need is that 'hide all' button for each set of five buttons. When I hit that I want it to trigger the 5 buttons to its right, or if that's too hard, 5 specific button names. How is that done?