Down and up button to unhide or hide rows

**Rocky2013** · 04-25-2013, 09:48 PM

Hi,
I like to click a "down" button (image) to unhide the rows, down button will switch to "up" button and text will be changed.
To unhide the rows, click "up" button then text will change to a different text.

Please advise. Thanks of your help.

**AlvaroSiza** · 04-25-2013, 11:24 PM

My opinion (and it's worth what you paid for it):

I think you're going to have a tough time with the route you have chosen. MS provides both form and active x controls to function adequately in scenarios such as these. An ActiveX togglebutton, for example, is perfect for this. However, you will lose your preferred formatting.

I could be wrong, and often am, but under the scenario you describe, you will have to have both pictures (the orb/up, orb/down) placed out of sight, called and positioned upon worksheet activation, have a boolean trigger somewhere to determine the state (hidden or unhidden) of the rows, apply the appropriate macro, re-call the opposing picture, and re-apply the opposing code functionality for use when user wants to invoke the alternate environment.

Feels heavy. You could use a togglebutton with 10 or so lines of code behind it and you would be on to the next task.

Again, my opinion. Good luck.

**Rocky2013** · 04-26-2013, 08:55 PM

Thanks for the reply. I have seen this was done in HTML. I could use the "group" with plus sign on the far left of vertical bar. I do not like the looks.
Worst case I may use fonts liked triangles instead of down and up bottons (pictures); if that works. But I need to click the same cell to change the
triangle angles back and fore.

Thanks