PlasticMacro
09-20-2019, 12:18 PM
I have a main Workbook called MASTER WORKBOOK that has many sheets. One sheet, SETUP&INVENTORY, has a macro that attaches said sheet to an email with a new file name (just the single sheet, Macro 1)). That new sheet has some cells referencing another sheet in MASTER WORKBOOK. When I "Break Links" it kills the macros I have on the sheet, even though the VBA code is transferred with the sheet to the new file. It seems to me that the macros on the new sheet (2 and 3) are linked to the VBA code on the sheet in the MASTER WORKBOOK. How do I keep this from happening?
For the solution, I need to be able to click Macro 1) to attach the sheet to an email. After it's saved in a new location, I need to be able to use Macros 2) and 3) without them linking back to MASTER WORKBOOK.
I have attached MASTER WORKBOOK and an already saved off SETUP&INVENTORY sheet name 401-010-4172.
For the solution, I need to be able to click Macro 1) to attach the sheet to an email. After it's saved in a new location, I need to be able to use Macros 2) and 3) without them linking back to MASTER WORKBOOK.
I have attached MASTER WORKBOOK and an already saved off SETUP&INVENTORY sheet name 401-010-4172.