Member
Posted 16 June 2014 - 02:23 AM
Dear Sir,
When I save my macro enable workbook, every time one message appears (i.e. "Privacy warning: This documents contains macro, ActiveX control, XML expansion pack information or web components. These may include personal information that cannot be removed by the documents inspector".).
Kindly let me know if there is any option by which I can skip the message and save the workbook directly.
Thanks and regards
Rathin Das
Forums Administrator
Posted 16 June 2014 - 06:09 PM
Hi Rathin,
This warning is part of Excel's Trust Center options.
To disable it, you'll need to click: File > Options > Trust Center > Trust Center Settings... > Privacy Options
...and then un-tick the option Remove personal information from file properties on save.
For more on the Trust Center, see the video lesson: Expert Skills Lesson 9-14: Understand Trusted Documents.
I hope this solves your problem. If not, please feel free to reply to this post and I will try to offer further advice.
Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.
0 members, 0 guests, 0 anonymous users
ExcelCentral.com Support Forums
