Macro warning with no macros...

[DanExcel]

Hello,

I have a worksheet where I had macros at one time, but subsequently deleted them. With this worksheet, I still get a warning about macros whenever I open the sheet. Has anyone else had this problem? It's not a huge problem, but it is an annoyance, particularly when I distribute the sheet to others...

Thanks,

DanExcel

 

[sen_edp]

Did you remove the module that contained the macros? The presence of an
empty module will trigger the macro warning. To remove a module, make sure
the Project explorer window is open in the VB editor (View|Project
Explorer), right click the module and choose "Remove Module".

 

[Nimrod]

Why not just copy the sheets to a new workbook, delete old workbook , rename new one ?

 

[DanExcel]

sen_edp,

Removing the module took care of it. Thank you.
Thanks to Nimrod too for the suggestion.

-DanExcel