Have you ever come across a scenario where you created a macro and deleted it before finally saving the file? If you have, then chances are that when you re-open such a spreadsheet, Excel warns you and asks if you wanted to disable the created macros. Although this is odd since there are no macros in the workbook, it is quite natural. Excel creates a module to hold a macro as soon as it is created. Even though you have deleted the macro code itself, the module is retained by the application for holding any future macros.

To stop this, carry out the following steps:

Open the Workbook in question.

Go to the 'Developer' tab.

Click the 'Visual Basic' button appearing under the 'Code' group of the tab. The 'Microsoft Visual Basic' editor opens.

Notice the 'Project Explorer' panel appearing on the top- left side of the editor window.

NOTE:

If not visible, press [ctrl) + [R) to enable the 'Project Explorer' panel.

A folder named 'Modules' appears in the hierarchical tree of the 'Project Explorer'.

Expand the folder to view its contents.

Right-click on the module in the folder that you want to delete.

Select the 'Remove <Module_ name> .. .' option from the context menu that appears.

Click the 'No' button on the dialog box that pops-up to remove the existing module.

Close the 'Visual Basic Editor' window.

Save and reopen your workbook.

Since your workbook contains no modu,les, you will not receive any notification when you r'e?pen the required file.