You may get warning message about the Document Inspector when you want to save Excel file. Is there a script can remove this warning?
Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector.
Remove Document Inspector Warning
- Go to File > Info
- and Click in "Allow this information to be saved in your file".
- Goto File in the upper left hand corner
- Options > Trust Center > Trust Center Settings > Privacy Options >
- Un-check the check box that says "Remove personal information from file properties on save"
- Hit OK.
Remove Document Inspector Warning By VBA
'------------------ Copy to ThisWorkbook ------------------ Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ActiveWorkbook.RemovePersonalInformation = False End Sub