Activate Macro Button Located In Another File

[Aria]

Hello,
My macro is located in macro.xls. How do you create the flexibilty to
be able rename this file and still be able to call it within another
file?

When I assign a button towards another file called Template.xls, I have
(Both files are opened at this point):
With mybutton
..OnAction="'Macro.xls'!ClearTemplate"
End With

If Macro.xls changes name prior to assign the button, how do I alter the
OnAction line? I've tried fiddling with;
Set curwksmacro = ActiveSheet
but I just couldn't point the OnAction line to refer to curwksmacro's
ClearTemplate macro.

Please help.

Thanks,
Aria

 

[Dave Peterson]

The code to assign the macro to the button is in the same file?

With mybutton
OnAction= "'" & thisworkbook.name & "'!ClearTemplate"
End With

 

[Aria]

Hi Dave,
It works. Thank-you so much. Yes, the code to assign the macro is also
within macro.xls.

Thank-you so much.
Aria