How to Delete All Macros from Excel Spreadsheet?
User Query: Hey!! From past few days I am facing issue in Excel Worksheet. By mistakenly I downloaded Excel from an email and run Macro. After that, I have realized that virus has been affected my system and it is now not working properly. I wasn’t aware about these malware activities. Now, I want to get rid of it by using best solution to delete all macros from excel. Is there any solution available through which I can perform this task? If yes, then kindly suggest me the same.
- Leonardo, Australia
As we all know that VBA Macros are beneficial in multiple tasks. By using VBA Macro programming code we can create new functions in Microsoft Excel also. But there are many disadvantages also of using Macros. There are many unwanted users who use to send VBA macro code along with some viruses as well.
At that time most of the users look for how to delete all macros from excel sheet.
What are the Different Techniques of Remove Macro from Excel VBA?
There are multiple techniques through which user can perform this task. Here we are going to discuss some of the methods.
Technique 1: Delete Macros from Excel & Save File in XLSX Format
This is one of the simplest method if you wish to remove all of the macros at once. By saving the workbook in to XLSX format. Let’s have a look at this procedure:
- First, Open XLSM(Excel 2019, 2016, 2013, 2010, and 2007 Macro Enabled File) format using Excel. Then, click on the File
- After that, choose Save a Copyoption from the given dropdown menu.
- Then, hit on the Browsebutton to for selecting a specific destination path.
- Thereafter, Fill in the nameof the file you wish to save in the Save As dialogue box.
- Now, click on the “Save as type” and choose Excel Workbook (*.xlsx) option from dropdown. Press on Savebutton to continue.
- Finally, a dialogue box will appear showing information as VBA Macro will be removed, if you save file in XLSX format. Then, choose yesoption to delete all macros from Excel.
Drawbacks of above-mentioned solution
The above mentioned technique will allow to delete all macros from Excel sheet. Therefore, if you wish to erase only specific VBA macro then this is not possible. Also, it is a time-consuming task as users can remove all macros from Excel VBA files one by one.
Let’s have a look on the other technique.
Technique 2: Use Developer Option to Remove Specific Macros from VBA Excel
In the above solution we have seen the possibilities of remove macro code in excel. This technique will show that how user can delete specific macros from VBA file.
- Firstly, open the XLSM VBA project using Microsoft Excel program. Select the Developeroption from the menu bar.
- Thereafter, hit on Macros It will display all of the macros in the workbook in the Macro dialogue box.
- After that, select This Workbookoption from the dropdown of Macros.
- Now, choose the Macro namethat you want to remove VBA Macros from Excel Sheet.
- Finally, user have to click on the Deletebutton to eliminate selected Macro from Excel VBA project.
Technique 3: Automated Solution to Delete Macros from Excel – Direct Approach
The above-mentioned solutions are not easy and good for the users. So, it is best to avoid them and use Turgs VBA Macro Eraser Wizard for best results. Its advanced features will help users to remove macro from excel object.
This software will help users in eliminating macros from multiple file extensions as well. They also provide dual option for uploading VBA projects. By following the below-mentioned steps users can easily complete the task.
User Can Also Read: Remove VBA macros from word document
How to Remove Macro from Excel Workbook – Complete Procedure
There are few steps which user have to follow for completion of the work:
- First, install and run VBA Macro Eraser Software on your Windows Operating system.
- After that, user have to upload the VBA Files in the software interface via Select Files or Select Folder option.
- Then, select the required VBA projects from which user have to remove the macros.
- Thereafter, user have to browse destination path for saving the final output data.
- Click on remove button to start the delete macros from excel file procedure.
Concluding Lines
The above post describes about how user can delete all macros from excel. There are many users who used to face issues in performing this task. But this blog post will clear all the doubts of the users as both manual and professional solution are mentioned here. But as mentioned-above user can go with professional solution to avoid the drawbacks.
We hope after reading this post user will not left with any sort of queries. But if still issue persists try connecting with our live support team. They are available 24*7.