ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove macro and security warning (https://www.excelbanter.com/excel-programming/385218-remove-macro-security-warning.html)

muyBN

remove macro and security warning
 
I created a macro then deleted it after I didn't need it anymore but the
macro security warning still displays when I open Excel the next time. How do
I permanently delete the macro module? I don't want to change the security
level.

--
Bryan

Mark Dullingham

remove macro and security warning
 
You need to right click the sheet tab and 'view code', expand to module list
in the project explorer window, right click any modules you find (and don't
want, these, although empty, are causing the warning popup) and select
remove, when prompted about exporting select no.
Save your workbook and re-open. Should be OK now.

"muyBN" wrote:

I created a macro then deleted it after I didn't need it anymore but the
macro security warning still displays when I open Excel the next time. How do
I permanently delete the macro module? I don't want to change the security
level.

--
Bryan



All times are GMT +1. The time now is 10:34 AM.

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