I’m using the following code to create a new workbook which will include sheets that have been ticked on the ‘System Selector’ sheet. For testing purposes the only sheet available at present is the ‘System 66-Inert Gas’. Eventually there will be a sheet in this workbook for all the systems listed on ’System Selector’.
The macro ‘mainLW3’ is working fine. It creates a new wb with the ‘Master’ and ‘System 66 – Inert Gas’ sheets, when the check box is ticked. However, it does not copy the macros from the original ‘System 66 – Inert Gas’ sheet. These are the ‘CheckedBy’ macros.
How can this be achieved? I noticed that the created wb saves as an xlsx not an xlsm!
I’ve attached a test copy of the wb to help out. Note this will save to drive D: if not changed.
Any help appreciated.