Macro assigned to the button(Form control) doesn't work in copied file with new name

[TomaszM]

Hello,
I wrote a macro which should work internally in the file.
This file is copied (as a file) to the new one every week.
I noticed a problem, that my macro in the new (copied) file is references to the previous (original) file. It opens previous file and starts working.
I see that in the window Assign macro - there is automatically a path of file and then the macro name.

In my example the name of macro is: "KasujeKomentarze_3".

When I remove the path and click OK, it will be saved

but when I come back here again - the path is still visible

When I run macro in copied file from button, it open the previous Macro and run, not in this file.
When I run macro from the VB - it works properly in actual file.
In the code I used not direct reference like ThisWorkbook.Name.
What I'm doing wrong then?

 

[Zot]

Try right click on button. Re-assign the macro. It should refer to current workbook

 

[TomaszM]

Yes, I'm sure this will help, but I have 3 parallel macros in 7 sheets, so it's not comfortable. How to manage it other way?

 

[Zot]

I meant delete current one and assigned new. You need to do only once. and it will stay.

 

[TomaszM]

Yes, but as I mentioned - I make new file every week - so your solution is to change the reference in all 7 sheets - 3 macros - so 21 changes. I think there should be a faster way.

 

[Zot]

Yes, but as I mentioned - I make new file every week - so your solution is to change the reference in all 7 sheets - 3 macros - so 21 changes. I think there should be a faster way.

I thought it is only once. How you copy it? Copy worksheet and then copy macro to another workbook?

 

[TomaszM]

Just copy file in explorer or similar - in the fastest way

 

[Zot]

Do you really need to copy each time because of previous data? If not, why not just save the original as template and reuse it. Will not have such problem