Wednesday, May 15, 2013

How to Remove Hidden Macros in an Excel Spreadsheet


1. Double-click the Microsoft Excel document you want to edit. This opens the document and loads the Excel application.
2. Click the 'View' menu option and select 'Unhide.' In the section labeled 'Personal,' select 'Unhide workbooks' from the list of options.
3. Click the 'Developer' tab at the top of the Excel window. If you don't have the Developer tab, click the Office button and select 'Excel Options.' Click the 'Popular' tab and select 'Show Developer tab in the Ribbon.' Press the 'OK' button.
4. Click the 'Macros' button in the 'Developer' tab. A pop-up window opens with a list of macros programmed for the spreadsheet.
5. Click the name of the macro you want to delete. Click the 'Delete' button. Click 'Yes' to confirm that you want to delete the macro. It's now deleted.

Blogger news