I have a "master" workbook whose purpose is to take a "raw" excel file and convert it into a newly formated workbook. The intent is to give the newly formatted file to other users and have it operate as a standalone file with functionality that has been added to it from the "master" file. With the "master" file open, I click a button and the "raw" file opens, is re-formatted, has a button (btn1) created on it and exports/imports the module containing the code assigned to run the (btn1) button. However, when I click the btn1 button, it opens the "master" file and is referencing the "master" file code that was exported to the "standalone" workbook. How do I ensure that btn1 references the code within its own workbook (that was exported/imported into)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Assigning a macro to a button on a different worksheet
- Thread starter NAC
- Start date
Similar threads
- Question
- Question
