ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   After deleting a macro, I still get the pop-up when opening file (https://www.excelbanter.com/excel-worksheet-functions/7650-after-deleting-macro-i-still-get-pop-up-when-opening-file.html)

Anne

After deleting a macro, I still get the pop-up when opening file
 
After deleting a macro, I still get the pop-up when opening my excel file
that asks if I want to enable or disable macros. How do I get rid of the
pop-up? There are no longer any macros in the spreadsheet.

Bob Phillips

Anne,

That could be because the module that the macro was in is still there. Goto
the VBE, and with that project, check if there are any modules. If so, right
click it in the explorer window, and choose Remove (don't export it).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anne" wrote in message
...
After deleting a macro, I still get the pop-up when opening my excel file
that asks if I want to enable or disable macros. How do I get rid of the
pop-up? There are no longer any macros in the spreadsheet.




Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Anne" schrieb im Newsbeitrag
...
After deleting a macro, I still get the pop-up when opening my excel

file
that asks if I want to enable or disable macros. How do I get rid of

the
pop-up? There are no longer any macros in the spreadsheet.




All times are GMT +1. The time now is 11:35 PM.

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