Macro deletion

[tregrad]

How do i get rid of the " enable macro or disable macro " box that comes up everytime I open my work sheet. I have deleted them and yet it still comes up. I only made a couple of them while I was getting some help so I dont have many of them at all.

can I "delete ALL macros in all sheets" ? I dont need them and the warning box is really irritating me.


Thanks again.

[jasoncw]

If you just deleted all of the code out of the modules, it will still think there are macros in the workbook. You need to remove all modules (not sheets or ThisWorkbook, just the modules and/or userforms, if applicable). To do this, right-click on the module, and select remove.

[tregrad]

If you just deleted all of the code out of the modules, it will still think there are macros in the workbook. You need to remove all modules (not sheets or ThisWorkbook, just the modules and/or userforms, if applicable). To do this, right-click on the module, and select remove.

where is the module to right click on?......remember speak slow to me lol

[jasoncw]

Hit ALT + F11 to get into the VBE. On the left side, you should see your project (should show the file name). If you do not see the project, then hit CTRL + R to show the project explorer. Once you see your file, click on the + to expand, and you may see "Module1". If you see this, this is the cause. Right-click on it, and remove.

[tregrad]

Thank you very much Jason that was the ticket