Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 42

You may want to remove a code module that is no longer needed. To do so, follow these steps:

1 Select the module’s name in the Project Explorer.

2 Choose File ⇒ Remove xxx, where xxx is the module name.

Or

1 Right-click the module’s name.

2 Choose Remove xxx from the shortcut menu.

Whichever method you choose, Excel asks you if you want to export the module before removing it. Click Yes to create an export file that you can re-import into your project if you find you deleted it in error.

You can remove VBA modules, but there is no way to remove the other code modules — those for the Sheet objects, or ThisWorkbook.