remove macro and security warning

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top