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




*** Sent via Developersdex http://www.developersdex.com ***

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

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

Aria wrote:
>
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson

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

*** Sent via Developersdex http://www.developersdex.com ***