Macro Warnings on Save

Question

How can I turn off the pop up warning that Excel displays upon saving a workbook containing a macro?

The warning is the one referring to personal information being saved?

The warning is just one more thing to have to explain to a user of the workbook.

Mac, Office 365  2016

Answer 1

I've been up to date on both Office and Mac for several days. (The latest Office update was just this past week.) I created the new workbook as you suggested and didn't get the message. I looked at preferences and saw the difference:

Privacy & Security > Privacy > "Remove personal information . . ." check box. For others who read this: if you check this box and are using macros, you will get the alert. If you leave it unchecked, no alert. I'd leave it unchecked when developing a workbook on your own computer. If you share the workbook later, you will have to decide on the "remove personal information" option in Preferences.

Thanks for this suggestion and the lesson, Jim. It solved the problem.

Answer 2

Hi

What version of Excel do you have? Please go to the Excel menu and choose About Excel to find out, and please reply with that information. You should have version 16.15

If you have any other version, please install updates

Ensure your Mac and Office have the latest updates. Here’s how to install updates:

Make sure your Mac has a working internet connection, then:

1. Update Mac OS X. Open the App store and click on the Updates button. Install the updates.
2. After, in any Office application go to the Help menu and choose Check for Updates to launch the AutoUpdate app. Let AutoUpdate install updates and then restart your Mac.

If you use Antidote, Webex, Silverlight, EndNote, Zotero or other add-ins there is a potential for crashes unless you also update your add-ins to the latest update. Install updates for these programs if you have them.

I do not see this warning when saving workbooks with Macros.

If you open a new, blank workbook, add a simple macro, and save it, are you still seeing the dialog?

Answer 3

Kerry.Hill, the Trust Center doesn't exist on Mac. Can you look at the link below and tell me if it helps you ?

https://support.office.com/en-us/article/enable...

Seems it works on my Mac.

Answer 4

Thanks for your reply, Alexander.

Your suggestions may work for Windows. Mac Excel doesn't have a "Trust Center" and the options the article suggests don't seem to exist in Excel "Preferences > Privacy" settings.

Still hoping for a Mac answer.

KH

Answer 5

Hello Kerry Hill, I am not sure to understand exactly your problem but I have a few things to submit to you :

First, see the link below about enabling Macros :

https://support.office.com/en-us/article/enable...

If the message is about personnal information, try to follow the instructions in the post below :

https://answers.microsoft.com/en-us/msoffice/fo...

If you want macro not to show alerts or messages, use this instruction : Application.DisplayAlerts = False

I hope you will find your answer,