Repeat steps 2 through 4 for any other modules you want to remove.When asked if you want to export the module before removing it, click on No.The actual wording of the option will include the name of the module you want to remove, such as Remove Module1. Choose the Remove option from the Context menu.(Remember that macros are stored in modules, and that you should only right-click on a module that is associated with the workbook that you want to cleanse.) Excel displays a Context menu. In the Project Explorer (upper-left corner of the Editor), right-click on a module that you want to delete.Press Alt+F11 to display the VBA Editor.The third approach is to simply work with the existing workbook and is a viable choice if you feel comfortable with macros in the first place. You can now save the new workbook using any file format you desire.

Your worksheets have now been moved to a new workbook-one that does not have any macros attached to it. Re-hide any worksheets you unhid in step 1.The macro corruption most likely exists in the current. The same problem as above occurs: 'The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. I've created a workbook with macros in Excel 2010 and couldn't run it in two computers with office 2010. Make sure the Create Copy check box is not selected. I'm getting the same problem, but with Excel 2010.Using the To Book drop-down list, choose (new book).Excel displays the Move or Copy dialog box. Choose Move or Copy from the Context menu.Right click on one of the worksheet tabs.(Click on the first worksheet tab, then hold down Shift as you click on the last worksheet tab.) Select all the worksheets in the workbook.Unhide any worksheets that may be hidden.The second approach is essentially a variation on the 'new workbook' approach: This approach removes all macros as they cannot be saved in this workbook format. The first (and easiest) method is to simply use Save As (press F12) and use the Save As Type drop-down list to specify that you want to save the workbook in XLSX format. There are three ways you can accomplish this task. Gerald asked if there was a way to get rid of all the macros in an Excel workbook, without the need to individually delete them.

Delete vba project excel 2010