How To Remove Macros From Excel?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
1. Open the Excel file.
2. Go to the “Developer” tab on the Ribbon. If you don’t see it, go to File > Options > Customize Ribbon and check the Developer box.
3. Click on the “Visual Basic” button.
4. Select the project that contains the macro by double–clicking on the project name.
5. Double–click on the module that contains the macro you want to delete.
6. Delete the code for the macro.
7. Save the workbook when prompted.
8. Close the Visual Basic Editor.
1. Open your Excel document and click the “Developer” tab.
2. Select “Visual Basic” in the Developer tab.
3. In the Visual Basic window, select “Modules” in the Project Explorer window.
4. Right-click the module that contains the macro you want to delete and select “Remove Module” from the drop-down menu.
5. Click the “Yes” button in the pop-up window to confirm your selection.
6. Close the Visual Basic window and save your document. The macro will no longer be available in the Excel file.