chingilou
05-27-2022, 05:20 PM
Hello everyone
under excel 2016 I have an xlsm workbook with several sheets which contain macros in the sheets themselves not only in the modules (can't do otherwise)
I would like to create a button that allows me to copy the sheets ("Hanifatoys", "Aternal", "Arba") to a new workbook in fpath&fname
-1-and this new workbook must not contain the macros of the sheets of the source file (even changing the extension during the "saveas" does not work)
-2- and also if possible to delete (not hide) the shapes that have the same "AAA" names from the sheets of the new workbook
-3- all this without formulas and without links in the new workbook
thank you
under excel 2016 I have an xlsm workbook with several sheets which contain macros in the sheets themselves not only in the modules (can't do otherwise)
I would like to create a button that allows me to copy the sheets ("Hanifatoys", "Aternal", "Arba") to a new workbook in fpath&fname
-1-and this new workbook must not contain the macros of the sheets of the source file (even changing the extension during the "saveas" does not work)
-2- and also if possible to delete (not hide) the shapes that have the same "AAA" names from the sheets of the new workbook
-3- all this without formulas and without links in the new workbook
thank you