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