0

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.

nik
  • 101

2 Answers2

1

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.

Sir Adelaide
  • 4,977
  • 2
  • 16
  • 36
0

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.

Arvind
  • 69