How can I Hide/Unhide grouped objects using a button

[Dude to Excel Dude]

Hi, I'm new to the macro world. I'm trying to hide certain grouped objects in a sheet when using another object as a button and clicking it with my mouse.

My button has the following command to hide some columns:


-------

Sub Hide_Column()

Columns("B:L").Hidden = Not Columns("B:L").Hidden

End Sub

-------


What I want to accomplish is that when I press that object I wanted to hide/unhide the columns as shown in the command above but also hide/unhide a set of grouped objects I named "Group 1".

Thank you for your advise in advance,
Dude

[LeapingLizard]

Yo Dude,

Try something similar to this;

Please Login or Register  to view this content.

LeapingLizard

[Dude to Excel Dude]

Thank you! It works.