Tuesday, September 18, 2012

How to Disable One Macro in Excel 2003 Using the VBA


1. Open the Microsoft Excel 2003 software and access the worksheet containing the macro you need to disable. Navigate to the 'Tools' option at the top of the screen and click the 'Macro' option.
2. Select the 'Macros' entry and click 'This Workbook' to see a list of macros associated with the spreadsheet. Scroll through the list and click the name of the macro you need to disable.
3. Click 'Delete' to remove the macro from the worksheet. Close the 'Macros' window and return to the 'Tools' menu if you want to disable a macro by manually deleting the code.
4. Choose the 'Macro' option and select the 'Visual Basic Editor' entry. Click the name of the worksheet at the left end of the window that contains the macro.
5. Scroll down to the start of the macro, which begins with 'Sub MacroName().' Highlight the opening segment of the macro and scroll down to the ending 'End Sub' command. Press the 'Backspace' key to delete the macro.
6. Click 'File' and choose 'Save' to save the changes to the VBA code.

Blogger news