bressler4534
New Member
- Joined
- Aug 9, 2022
- Messages
- 1
Hello, I have created a template spreadsheet containing a button form control in my main workbook "Book1" and have written a macro titled "Copy" in Book1 to copy the template sheet to Book2. In the same macro titled "Copy" I have also been able to copy "Module5" from Book1 to Book2.
My goal is to create a macro in Book1 that will link the button in Book2 to Module5 in Book2. That way I do not have to click assign macro in Book2 every time I run "Copy". I have tried various VBA codes on other forums with no luck. Is this possible to do through a macro located in Book1 and if so, is there a generic code to do so? If anyone is able to assist I would greatly appreciate your help. Thank you!
My goal is to create a macro in Book1 that will link the button in Book2 to Module5 in Book2. That way I do not have to click assign macro in Book2 every time I run "Copy". I have tried various VBA codes on other forums with no luck. Is this possible to do through a macro located in Book1 and if so, is there a generic code to do so? If anyone is able to assist I would greatly appreciate your help. Thank you!