VBA Hide/Show Group of Shapes

[Kaladin]

Hey, guys.

I have a bunch of shapes that I grouped together. I want to Show/Hide them with a macro.

I tried ActiveSheet.Shapes("Group 1").Hide and that didn't work at all.

Is there a way to hide the whole group or show the whole group or do I have to show/hide them all individually?

 

[JoeMo]

Try:
ActiveSheet.Shapes("Group 1").Visible = False

to hide all shapes in Group 1.

 

[Kaladin]

You're brilliant. I was thinking of UserForms... My goodness. I've spent too long away from Excel.

 

[JoeMo]

You're brilliant. I was thinking of UserForms... My goodness. I've spent too long away from Excel.

You are welcome - thanks for the reply.