How to Remove Macros from Excel?

Open the Excel file

Save a backup copy if needed

Go to File

Select Save As

Choose Excel Workbook (*.xlsx)

Click Save

Confirm macro removal if prompted

Open the workbook again

Press Alt + F11

In the VBA editor, open the project

Delete all modules, class modules, and userforms

Remove code from worksheet and workbook objects

Save the file

Close and reopen the workbook

Go to File

Select Options

Open Trust Center

Click Trust Center Settings

Select Macro Settings

Disable macros as needed

Use Developer tab

Click Macros

Delete unwanted macros

Remove any add-ins containing macros

Check for embedded ActiveX controls if needed

Save the cleaned workbook

Suggested for You

Trending Today