{"id":1113,"date":"2018-07-01T11:11:31","date_gmt":"2018-07-01T11:11:31","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1113"},"modified":"2024-03-28T13:18:26","modified_gmt":"2024-03-28T13:18:26","slug":"privacy-warning-error","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/privacy-warning-error\/","title":{"rendered":"Privacy Warning Error in Excel"},"content":{"rendered":"\n
When you try to save your macro-enabled worksheet sometimes you may experience the following error.<\/p>\n\n\n\n
Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed from the Document Inspector<\/strong><\/p>\n\n\n\n The first way you can deal with this problem is by applying a macro to a button<\/a>.<\/p>\n\n\n\n Now, instead of using Excel save options you can click this button.<\/p>\n\n\n\nAssign a macro to a button<\/h2>\n\n\n\n
Sub noErrorSave()\n Application.DisplayAlerts = FALSE\n ActiveWorkbook.Save\n Application.DisplayAlerts = TRUE\nEnd Sub<\/pre>\n\n\n\n