Excel 2007 : Toggle Button

I have set up a Toggle Button that controls the 'Show Detail' and 'Hide Detail' Level 1 and Level 2 Group/Ungroup option in Excel (see attached sample), using the following code.

Please Login or Register  to view this content.

My question is this.

Is there a way to adapt this code to control individual ranges of grouped columns? For example, if I have columns 2 to 6 grouped and then columns 10 to 15 as a second group, is there a way to add a second toggle button so that each button controls a different grouping?

Hi Andy

Thanks for your reply (and sorry for the delay in mine - been trying to sort other issues).

My lack of VBA knowledge is showing. Tried your code but I get errors. I have left Button 1 showing and hiding all levels, but I want Button 2 to just show and hide a single set of grouped cells.

Button 1 Code

Please Login or Register  to view this content.

Button 2 Code

Please Login or Register  to view this content.

I have attached the spreadsheet sample. Not being familiar with the terminology and functionality of VBA I am just tweaking relatively randomly without understanding the errors.

Are you able to point me in the right direction, again... Many thanks.

Andy

Many thanks once again, that works perfectly...