Show/Hide Grouped Rows/Columns

**HangMan** · 06-24-2012, 01:27 PM

I'm using an Active X Toggle Button to show/Hide Grouped Columns with the following code:

Please Login or Register  to view this content.

However, I would like to use a 'Shape' instead of a 'Toggle Button'. How would I adapt the code to achieve this?

**xladept** · 06-24-2012, 01:44 PM

Hi Hangman,

You could name your shape:

Please Login or Register  to view this content.

Then you could test if it was selected in a Worksheet_Change Event:

Please Login or Register  to view this content.

or, of course, your toggle code.

**HangMan** · 06-24-2012, 02:30 PM

Hi xladept,

I'm new to VBA and I'm unsure if I use a shape whether this has to run using a macro or quite how the code would look for a shape rather than a command button?

I tried replacing the 'Toggle Button' references in my code with the name of my Shape, but that doesn't work, so I'm not sure how to adapt the code correctly?

Are you able to provide an example? The attached worksheet, shows it working with a toggle button, but I want to code the shape to do the same thing and that is where my knowledge falls down!