Hi There,

I am using Microsoft Excel for Mac 2011.

I have been working on a report in excel, the original template I got were just some tables to be fill out and did not have any formulas in it. when open there were no security warnings for macros in the file.

To be more efficient working on my report I have used some formula such as vlookup & sumifs for calculation. When I reopen the file after I finished the report and saved it, excel gives a warning saying this file contains macros and let me choose whether I want to enable or disable the macro.

This is very strange to me, as I did not add any macro in the process and also checked the list of macros in the file under the visual basic tool bar, there is nothing.

Do you know why this is happening? and how to remove the so called "macro" that is given the warning? Since I need to send the file to my boss. I don't want them to experience the same warning and wondering what did I do to the file.

Thank you and I would really appreciate your help on this!!!!

Lin

Hi Lin,

Macro security settings are located in the Trust Center.
Go to Excel Options and then click Trust Center followed by Trust Center Settings, and then click Macro Settings.
You can select from the below options:
1. Disable all macros without notification
2. Disable all macros with notification
3. Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification
4. Enable all macros (not recommended, potentially dangerous code can run)

For more details please refer the below link.
https://support.office.com/en-sg/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12

Thanks
________________________________________
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

HI Arijit_Dey,

Thanks for a quick response and the information you provided. 

Would the step you recommended just check the setting on my local machine? or it changes the setting of the file as well?

The warning doesn't really bother me, and my concern is when I send it to my colleagues and my boss, would they get the warning?

And I am also curious why it even gives this warning when there is no macro in the file?

Thanks,

Lin

Hi Lin,

Did you save it as XLSM format? It might be a factor.

In additional, We support Office for Windows in the current forum, since this question is about Office for Mac, I suggest you post the question in Office for Mac forum:

http://answers.microsoft.com/en-us/mac/forum/macoffice2011?tab=Threads

Regards,

The setting are machine specific. Just look for module in your workbook  by a right click on the sheet that you were working on and select View code and remove it if exists.

Thanks
________________________________________
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.