This will open the Save As dialog box.Select the folder where you want to save the new file.Select Save As from the options on the left sidebar (if you’re on older versions of Excel, select Save As from the File menu).Open the XLSM or XLSB file that contains the macros.To save a workbook as XLSX, here are the steps to follow: The great thing about this method is that you can still hold on to the original document containing the macros, in case you think you might need them later. If you’re an experienced macro user, you might be aware that the only Excel files that can hold macros are those of the XLSM and XLSB formats (or the older XLS format).Īs such, if you save your Excel workbook in XLSX or any other format for that matter, your macros will be deleted or lost.Īn easy way to remove a ll the macros from an XLSM or XLSB format workbook is to save it as XLSX and then delete the original if needed (or keep it as a backup if needed). Method 1: Remove All Macros by Saving the Workbook in XLSX Format Method 3: Remove Macros using the Visual Basic Editor.Method 2: Remove Macros using the Macro Dialog Box.Method 1: Remove All Macros by Saving the Workbook in XLSX Format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |