Select shapes with same name but different number using VBA

[leojez]

Hello,

I have a button linked to a macro to toggle hide / show around 15 grouped shapes. I can achieve the effect I want by grouping all the shapes together as one group and then using that group name in the code, however, some shapes are set to move and others not move with cells, so it would be better to have all the groups independent of each other.

I tried to get the toggle effect using the group names (each group is named "Instruction1", "Instruction2", "Instruction3:, etc.) by using the wildcard aasterisk "*" as follows:

Sub Toggle_Help_Shapes_Portfolio()
    ActiveSheet.Shapes("Instruction*").Visible = Not ActiveSheet.Shapes("Instruction*").Visible
End Sub

to hopefully select any group beginning with "Instruction" and then any number after it, but this doesn't work. Any ideas how to achieve this, please?

Thank you!

 

[leojez]

How did you group the shapes in, say, Instruction1? Describe the procedure you used.

My apologies! I realized when I tried your code I didn't update the button macro link. It works perfectly - thank you!

 

[leojez]

How did you group the shapes in, say, Instruction1? Describe the procedure you used.

My apologies! I forgot to update the button macro link when I used your code. It works perfectly, thank you!

 

[My Aswer Is This]

Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.