Copy form controls to other workbooks

[Snackan1986]

Hi,

I have a macro that I have put in a form control. Once a month the entire sheet will be copied to another workbook including the formcontrol with the macro.

Problem is that when the sheet is copied the macro in the new workbook will refer to the old workbook, hence when running the macro the old workbook will open automatically which I donīt want it to do.


Anybody knows how to solve this? I could do it as an Add-In or put it in my personal macros however I donīt want to force an add-in to my collageous. Tried to solve it with an Active X-control but was not as easy just to copy and paste the macro.


I can email the workbook to anybody who wants to help if itīs need

[morevijay1982]

dear expert

do one thing
copy your macros code in notebook

every time create new form control and configure new macro name

and paste your code

i think this will solve your problem

keep in mind one thing where you write macro and link form control to it next time you cut paste said sheet

form control search parent workbook where script is written

do it for anything please revert

[davesexcel]

What's does the code look like?

[mikerickson]

How are you making the new copy of the Workbook?