Remove Excel Macros Security Warning

Even though an Excel workbook doesn’t contain any macros, sometimes when you open a file, a security warning appears.

securitywarning

This can happen if you recorded a macro in the workbook, then deleted it. A module is automatically created to store a recorded macro, but it’s not automatically deleted when you delete the macro.

Delete the Empty Module

Follow the steps in this video, to delete the empty modules in the workbook, and that should prevent the security warning from appearing.

If you prefer written instructions, there are detailed steps here to remove empty modules.

______________

You may also like...

4 Responses

  1. Contextures Blog » Bypass the Excel Macro Security Warning says:

    […] If the workbook doesn’t have macros, and you’re seeing a macro warning, you can follow the instructions here: Remove Excel Macros Security Warning. […]

  2. Jillian says:

    Hello,

    Thanks for doing the video, I had a spreadsheet that was driving me crazy with the security warnings, all gone now, thanks again.

    Jillian
    My Site:Aromatherapy Tips

  3. Peni Gardner says:

    I can’t seem to watch the video. However the written instruction is already enough thanks.

  4. Abigail says:

    Same thing here. The youtube links says “An error occurred. Please try again later.” But I did manage to download it using Internet Download Manager and it worked well. Nice guide Deb. Thanks for the post.

Leave a Reply

Your email address will not be published. Required fields are marked *