ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invisible macro? (https://www.excelbanter.com/excel-programming/305294-invisible-macro.html)

Cavemanz

Invisible macro?
 
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



Frank Kabel

Invisible macro?
 
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


.


Stefan Schier

Invisible macro?
 
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





mike

Invisible macro?
 
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


.


Don Guillett[_4_]

Invisible macro?
 
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






All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com