Move or Copy worksheet containing Form control

%3CLINGO-SUB%20id%3D%22lingo-sub-1726761%22%20slang%3D%22en-US%22%3EMove%20or%20Copy%20worksheet%20containing%20Form%20control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726761%22%20slang%3D%22en-US%22%3E%3CP%3EOdd%20issue%20I'm%20having%2C%20I%20have%20a%20template%20worksheet%20for%20data%20capture%2C%20every%20week%20the%20%22blank%22%20template%20is%20copied%20using%20the%20Move%20or%20Copy%20function.%20I%20have%20added%20to%20the%20template%20a%20form%20control%20button%20(with%20macro)%20which%20will%20pull%20data%20entered%20into%20a%20weeks%20worksheet%20and%20store%20in%20a%20historical%20data%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20copy%20the%20%22blank%22%2C%20the%20form%20control%20button%20doesn't%20copy%20with.%20This%20is%20working%20on%20other%20similar%20files%20and%20I%20can%20not%20figure%20out%20why.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1726761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728521%22%20slang%3D%22de-DE%22%3ESubject%3A%20Move%20or%20Copy%20worksheet%20containing%20Form%20control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728521%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814030%22%20target%3D%22_blank%22%3E%40wawizard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20your%20permission%2C%20add%20a%20file%20(with%20no%20sensitive%20data)%20from%20which%20you%20can%20accurately%20describe%20the%20problem.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EThat%20way%20you%20can%20be%20helped%20faster.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EAt%20the%20same%20time%2C%20the%20helper%20can%20find%20the%20sources%20of%20error%20better%20and%20faster%20in%20the%20file%20and%20offer%20you%20the%20best%20possible%20solution.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-footer%20source-or-target-footer%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Odd issue I'm having, I have a template worksheet for data capture, every week the "blank" template is copied using the Move or Copy function. I have added to the template a form control button (with macro) which will pull data entered into a weeks worksheet and store in a historical data sheet. 

 

When I copy the "blank", the form control button doesn't copy with. This is working on other similar files and I can not figure out why. 

1 Reply
Highlighted

@wawizard 

 

With your permission, add a file (with no sensitive data) from which you can accurately describe the problem. That way you can be helped faster.
At the same time, the helper can find the sources of error better and faster in the file and offer you the best possible solution.
 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)