Microsoft Excel - Eliminate Warnings About Non-Existent Macros (Excel 97/2000/2002)

Depending upon your set security level, Excel will usually warn you if a workbook you're tying to open contains macros, providing you with the option to cancel the process. However, sometimes you may wonder what Excel is warning you about--the workbook in question doesn't seem to contain any macros.

Most likely, a macro was at one time associated with the file. Even though the macro is now gone, the VBA module that is was stored instill exists. The module is empty, but Excel displays the warning message whenever you open the file.

Fortunately, it's usually easy to eliminate this nuisance. However, before making any changes to your file, it's a good idea to make a copy of the workbook, just in case you accidentally make a change that prevents something from working correctly.

When you're ready to modify the file, the first step is to see if there's a VBA code module associated with the file.First choose Tools | Macro | Visual Basic Editor from the menu bar. Next, look for a folder named Modules in the Project Explorer. If the Project Explorer isn't visible, choose View | Project Explorer from the menu bar.

Assuming you find a Modules folder associated with your workbook, double-click on it to reveal its objects. The folder can contain several module objects. Double-click on each module. If the macros were deleted, you should see blank code windows (although they might contain statements like Option Explicit, you shouldn't see any actual macro procedures).

Assuming that a module is indeed blank, you should be able to delete it with out any repercussions. To do so, right-click on the module icon in the Project Explorer and then choose Remove Module1 (or the appropriate name) from the shortcut menu. You'll then be given the chance to export it. Since you should have nothing to export, just click No. Repeat these steps for each module in the workbook, Finally, close the VBE and save the workbook.

Go back