Mastering Excel takes time and effort for a normal user. Unless you are an Excel expert, getting the hang of the advanced features might be a daunting and tiresome process. Unfortunately, not all commands are visible in an open worksheet. Removing Macros is a perfect example.
You can automate repetitive tasks and make new functionalities and functions with VBA macro codes. But at times, you may want to remove these codes or even delete specific codes. VBA Macros in Excel can help you save on time.
In this guide, I give you three different ways you can use to remove macros from an excel workbook.
How to remove all Macros by saving the Excel file in XLSX format
When working with Excel workbooks, you can only have macros in.XLSM, XLS, and.XLSB formats.
You can easily get rid of all the macros at once within your Excel workbook by saving it with the XLSX format. It is easier as you cannot have any macro codes in this file format by design. When you save the file, the codes will be automatically removed in cases you do.
Below are steps to follow to remove macros from your file.
1. Click the File tab on the far right corner.
2. On the drop-down list, click on the 'Save As' option. This option will be 'Save a Copy in the new Excel version.'
3. Click on the 'Browse' option to open a Save As dialog box.
4. In the Save As dialog box window, type in the file name with which you want to save it in the File name section.
5. Next, click on the drop-down arrow on the Save as type option.
6. Select the option' Excel Workbook (*.xlsx)' from the drop-down list.
7. Click the Save button.
8. After doing this, a Microsoft Excel prompt window appears. Click on Yes.
How to remove specific Macros from a workbook using the Macro dialog box
You can use this method to remove only specific macro codes from your workbook without having to delete all of them. Here are the steps to follow.
1. On the main menu ribbon, click the Developer tab.
2. Under the Code section, click on the Macros option to display a dialog box. Here you will see all the macros in the workbook.
3. In the displayed Macros dialog box, click on the drop-down arrow under the Macros in section.
4. Select 'This Workbook' in the drop-down list.
Select the macro name you want to delete in the given macro list.
6. Click the 'Delete' button. If you want to delete all macros, repeat the fourth and fifth steps.
How to remove Macros using the Visual Basic Editor
With this method, you get the most control as you can access all the macros. Below are steps to follow.
1. Tap on the "Developer tab" on the main menu ribbon.
2. Under the Code section, click on the Visual Basic option. You can also use the ALT + F11 shortcut
3. In the VB editor window, click on the View option > Project Explorer to see all the workbook objects.
4. Double click on the module or object with the macro code to open a code window.
5. Delete the macros you want to remove.