We can create a new document and then use the code to enable the option. Sub remove() ActiveWorkbook.RemovePersonalInformation = True End Sub You can right click or press and hold on a drive, file, and folder in Windows, and click/tap on Properties to see more details about the drive, file, or folder. Protection of document properties and personal information is used in case you don't want other people to change any metadata or anything in your document. The Security tab in the properties window of drives, files, and folders will allow users to change owner and modify permissions of the drive, file, or folder. In Excel 2013 this section is … I use Excel 2013 and Power View and SQL Server …
Since the reviewers' names are considered personal information, they're removed and replaced by the anonymous "Author" -- and of course there's only one Author, so all the colors collapse to one. Active 2 years, 6 months ago. SOLUTION: Click on File->Options to see Word Options dialog box. You can click on the remove Properties and Personal Information link at the bottom of the window, or click in a specific field to remove, edit or add values. Protect document properties. Viewed 68k times 55. ROOT CAUSE: Before uploading this document in sharepoint, author has inspected the document and removed the document properties and personal information as shown below. You could remove information about the author, comments or the subject from a document before sending it to a third party, or to add those information before you do. How to remove personal data from image files. Probably in Tools Options Security you have checked "Remove personal information from file properties on save". How to remove personal information from pictures Right-click the file and select Properties . Go to File -> Info. Though we fill and save it back in word document properties, it becomes blank. Hope that helps. Ask Question Asked 6 years, 5 months ago. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. 5. Click on Protect Workbook in the Permissions section. Learn more . Setting Excel to Remove Personal Information from the File Properties When You Save. be careful parts of your document may include personal information that cannot be removed by the Document Inspector. The following VBA code can be used to enable the "Remove personal information from file properties on save" option for Word 2010: ActiveDocument.RemovePersonalInformation = True. Every digital camera is different, but nearly all of them add at least some personal data to the pictures you take. Save the file as Normal.dotm and replace the current Word global template file with it.