After I have deleted a macro, everytime when I open that workbook, the
security alert keeps popping up. When I check for macro, there's none in the
macro list. Anybody has any idea on what to do?

Lim

Hi
see:
http://www.contextures.com/xlfaqMac.html#NoMacros

-----Original Message-----
After I have deleted a macro, everytime when I open that
workbook, the
security alert keeps popping up. When I check for macro,
there's none in the
macro list. Anybody has any idea on what to do?

Lim


.

Hi Lim,

have you checked if there is still code in the VBAProject?
To do so, press ALT+F11 to open up the code and open each of the workbooks
on the left to see if there is any code there.

Stefan

"Cavemanz" schrieb im Newsbeitrag
...
After I have deleted a macro, everytime when I open that workbook, the
security alert keeps popping up. When I check for macro, there's none in
the
macro list. Anybody has any idea on what to do?

Lim

Hi Lim,
Cancel all the modules, class modules and all the code
from your workbook and everything will go back tom normal.

mike

-----Original Message-----
After I have deleted a macro, everytime when I open that
workbook, the
security alert keeps popping up. When I check for macro,
there's none in the
macro list. Anybody has any idea on what to do?

Lim


.

You must REMOVE the module that the macro was in.
alt f11click on the + at the projectclick on + to expand modulesright
click on module remove modulesave
--
Don Guillett
SalesAid Software

"Cavemanz" wrote in message
...
After I have deleted a macro, everytime when I open that workbook, the
security alert keeps popping up. When I check for macro, there's none in
the
macro list. Anybody has any idea on what to do?

Lim