When I open my regular xls file, Excel asks me

This workbook contains macros. Do you want to disable macros before opening the file?

However, if I open Visual Basic Editor (alt+F11) there are no Modules listed and I am not aware of any macros used, the most complicated things are some matrix formulas.

Edit: The problem only occurs if I save in xls. If I change as xlsx (which sadly is not a solution for me) Excel does not ask.

Edit 2: The problem occurs as soon as I try to copy a sheet to another file and save. Even if I remove that sheet later, excel keeps asking me about enabling macros. Here is a test file for reproduction.

  • 2
    There can be codes in the worksheet code and ThisWorkbook code. – Scott Craner Mar 2 '17 at 22:01
  • See this article: contextures.com/xlfaqMac.html#NoMacros – Rob Sedgwick Mar 3 '17 at 6:53
  • I followed the link and removed everything in the code window (even that the field already seemed blank) for all objects - did not help – nik Mar 3 '17 at 10:52

If you go into Excel's options (File tab, Options), you'll see a section called Trust Center.

In there, you can add trusted locations and trusted documents. If you apply those to your case, Excel won't give security notifications for your document.

  • And just for the record, "non civil" way to do that – Alex Mar 2 '17 at 23:55
  • The OP doesn't have any macros (at least that he knows of) so not really the answer to the question which is why is the message appearing. – Rob Sedgwick Mar 3 '17 at 6:55
  • The workbook is used as template for a bigger process at which end it gets send to multiple recipients. So this does not really help me. – nik Mar 3 '17 at 10:54

Sometimes it happens even if there are no macros..try removing any module present in vba window,and save it.it will resolve the issue.

  • If you check the file you will see, that there are no modules – nik Mar 3 '17 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.