Prev: FormulaR1C1 using variables
Next: ActiveWorkbook.Save saves to wrong directory
From: Julie on 21 Apr 2010 16:56
That was no help!

"JZ" wrote:

> I wrote a macro and assigned it to a button in myToolbar. My goal is to let
> people to create their file based on this one and click the button to run the
> macro.
>
> First I saved it as a xls file, then I copy/paste and rename to create a new
> one. After I open the new one and click the button in the toolbar, it
> triggered the macro in the original xls file. Not so surprising because the
> button is associated with the subroutine in the original file.
>
> Then I saved it as a xlt file and use File > New to create a xls file using
> the template I jsut created. The new workbook was automatically named as
> myTest1 assuming the template file name was myTest.xlt. This time when I
> click the button it DID trigger the macro in the file myTest1 as expected.
> However I want to give this file a meaningful name. If I save it with another
> name, the button will not work anymore, similar to the first scenario it
> pointed to the subroutine in myTest1, which may not even exist if I didn't
> save it.
>
> So I guess it boils down to this: How to make customized button associate
> with the macro in the newly create file, not the template/seed file?
 | 
Pages: 1
Prev: FormulaR1C1 using variables
Next: ActiveWorkbook.Save saves to wrong directory