Hi all,
In need of some help. I have a main workbook which I use to generate costing sheets. These sheets are generated with macro button in for navigation. The costing sheet when completed is then exported from the main workbook and saved as it's own workbook for users to reference . However at times, we need to import these costing sheets back into the main workbook. But when I do and click the macro buttons on the imported worksheet it wants to run the macro from the saved cost sheet and not the main workbook it has been imported into. The main workbook has the same named macros in and so i want it to run these instead. Any help?
In need of some help. I have a main workbook which I use to generate costing sheets. These sheets are generated with macro button in for navigation. The costing sheet when completed is then exported from the main workbook and saved as it's own workbook for users to reference . However at times, we need to import these costing sheets back into the main workbook. But when I do and click the macro buttons on the imported worksheet it wants to run the macro from the saved cost sheet and not the main workbook it has been imported into. The main workbook has the same named macros in and so i want it to run these instead. Any help?
