Privacy warning error

When you try to save your macro enabled worksheet sometimes you may experience the following error.

Privacy warning:  This document contains macros, ActiveX controls, XML expansion pack information, or Web components.  These may include personal information that cannot be removed by the Document Inspector

Assign a macro to a button

The first way you can deal with this problem is by applying a macro to a button.

Sub noErrorSave()
Application.DisplayAlerts = False
   ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Now, instead of using Excel save options you can click this button.

You can also assign a keyboard shortcut, but be aware that when you use Ctrl + S you will override the standard save, so you may consider a different one.

Trust center settings

In order to turn off this message permanently, go to FILE >> Options >> Trust Center and click the button Trust Center Settings.

In Privacy Options uncheck the following checkbox.

Now, you should be able to save your file without annoying error messages.