![]() |
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 |
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 . |
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 |
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 . |
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