Macro Shape to Call another Macro Shapes

[andersen_yunan]

Hi, is there a way when I clicked a shape containing macro, it could call 1 or more shapes that are also macro assigned?

Thankyouu

 

[footoo]

Call the other macro(s) from the macro being run.

 

[My Aswer Is This]

Run numerous script from one shape using something like this:

Call One
Call Two
Call Three
Call Four

Etc.

The call function runs the script. Now obviously if your script is name Me you would have Call Me

This should work OK but it may not work properly depending on how your scripts are written.​

 

[andersen_yunan]

Hi, thank you for the reply

I'm quite new to macro and still learning. So, I'm trying to make one macro assigned to shape to be able to call a set of shape that have different macros assigned. Will the macro able to hide and show this set of shape upon when I clicked the first shape by using call?

 

[My Aswer Is This]

Not sure I understand your question.

Did you try the script I provided?

Did it work?

So are now saying you want the shape which runs the macro to hide itself after running the script?

 

[andersen_yunan]

Hi, sorry it's confusing

So each shapes has their own set of sub-shapes. Initally, let's say there are 3 shapes with each has its own 2 sub-shapes hidden. What i have in mind is that each time I click on one shapes, their set of sub-shapes would appear and if I clicked on other shapes, the previous set of shapes would hide themselves and let the other set of shapes appear.

I try your script but it didn't run because I didn't know script for hide and show for the sub-shapes

 

[My Aswer Is This]

Well I just thought you wanted to run several different scripts from one shape.

Your subject title says:

Macro Shape to Call another Macro Shapes​

My script only called your scripts

To do what you want would require a lot more information.
Like on what sheet are the shapes what are the names of the shapes and maybe more.

 

[footoo]

To hide a shape :
ActiveSheet.Shapes.Range("Button 3").Visible = False

To show a shape :
ActiveSheet.Shapes.Range("Button 3").Visible = True

 

[andersen_yunan]

Hi, footoo

Appreciate for the help. As for the script is it possible to apply it automatically hidden it if other button was clicked?

 

[footoo]

Hi, footoo

Appreciate for the help. As for the script is it possible to apply it automatically hidden it if other button was clicked?

Yes - you just have to add appropriate code to the macros.