Sticky macros

[Oz82]

MAKE IT STOP!!!!

I attempted to solve something with a macro, but found a simple
solution. I then deleted the macro, but now every time I open the fil
(or any of the hundred some-odd people I distribute it to) it warns m
of a macro being present. When I hit Alt+F8 to bring up the macro
list, it's empty.

This is causing some problems, since some of the people have viru
software that now see my file as a potential threat since it says i
has a macro.

Any insights

 

[Frank Kabel]

Hi
- open the VBA editor
- delete all modules (they are probably empty, but you have to delete
them)
- also check the worksheet modules and the workbook module for code
rests
- close the VBA editor
- save your workbook

 

[David McRitchie]

Would be good remove all traces of macros once yourself
in the manner that Frank indicated just so you know what's going on,
but you can do this automatically with a macro see Chip Pearson's
Coding for the visual Basic Editor
http://www.cpearson.com/excel/vbe.htm