Here's the deal:
I've edited a master shape in a stencil to have a new right-click action. This action is to run a macro, also saved in the stencil. Unfortunately it doesn't work. When I drag the master to a new document, then right-click it and select my new action, I get the following error:
Run-time error '424': Object required.
The action command in the shapesheet is:
=RUNADDON("Basic_Network_Shapes.myMacro"
Obviously, the stencil is the "Basic Network Shapes".
Any help? Am I wrong to encapsulate a macro in the stencil that contains the shape for which the macro was designed?
-with thanks
I've edited a master shape in a stencil to have a new right-click action. This action is to run a macro, also saved in the stencil. Unfortunately it doesn't work. When I drag the master to a new document, then right-click it and select my new action, I get the following error:
Run-time error '424': Object required.
The action command in the shapesheet is:
=RUNADDON("Basic_Network_Shapes.myMacro"
Obviously, the stencil is the "Basic Network Shapes".
Any help? Am I wrong to encapsulate a macro in the stencil that contains the shape for which the macro was designed?
-with thanks