If you need to remove a VBA module or a class module from a project, select the module's name in the Project Explorer window and choose File ^ Remove xxx (where xxx is the name of the module). Or you can right-click the module's name and choose Remove xxx from the shortcut menu. You'll be asked whether you want to export the module before removing it. See the next section for details. Remember: You cannot remove code modules associated with the workbook (the ThisWorkbook code module) or with a sheet (for example, the Sheet1 code module).
Was this article helpful?