remove macro and security warning

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top