I have a spreadsheet that once had a macro. Now it has no macros. I still get the macro security warning when I open the spreadsheet. I checked under Tools -> Macro, and now macros are shown. How do I stop the macro warning?
Make sure ALL modules are removed (the module itself needs to be
removed) and that all other event modules (Thisworkbook and the ones
behind the worksheets) contain nothing.
Not just all modules have to be removed, you also need to delete all content from the sheet modules
and the Thisworkbook module, including returns and spaces. Double click a module, press control+a and hit the del key.
Not just all modules have to be removed, you also need to delete all content from the sheet modules
and the Thisworkbook module, including returns and spaces. Double click a module, press control+a and hit the del key
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.