how to use the document inspector in excel

#How to use the document inspector in excel how to#
#How to use the document inspector in excel code#

In the Document Inspector dialog box, select the check boxes to choose the types of hidden content that you want to be inspected.

#How to use the document inspector in excel how to#

How to inspect a document in Microsoft Office?Ĭlick Check for Issues, and then click Inspect Document. Document properties and personal information this includes metadata, SharePoint properties, custom properties, and other content information Choose the File tab, and then choose Info. The Document Inspector includes the following built-in modules. Hi Guys, I own an Office Home&Business 2019 package and i stumbled upon a problem which i have no solution whatsoever for. How to use the Document Inspector in SharePoint? Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM). They can use the Document Inspector to remove unwanted information for example, before distributing a document. Hidden information can include: hidden data or personal information that you might not want to share in Word documents Can a Document Inspector be used to remove unwanted information? Private Sub WorkbookBeforeSave (ByVal SaveAsUI As Boolean, Cancel As Boolean) With Application.

#How to use the document inspector in excel code#

I found the code below to be placed in the workbook module. Therefore, I used my usual approach and searched the internet to find a solution. The Document Inspector feature in Word, Excel, PowerPoint, or Visio can help you find and remove hidden data and personal information in documents that you plan to share. The only annoying thing was the fact that I was getting the Document Inspector warning message. What do you need to know about Document Inspector?

The Accessibility Checker task pane appears next to your content and shows the inspection results.

In the Check for Issues drop-down menu, select Check for Issues. From the Info pane, click Check for Issues, then select Inspect Document from the drop-down menu.

How do I find and correct accessibility issues in Word?įollow these steps to open the Accessibility Checker.

In Excel, we are unable to print the hidden information that is removed by Document Inspector. Click the File menu, select the Info tab, and then select the Protect Document button. The Document Inspector displays different sets of Inspectors in Office Word 2007, Office Excel 2007, and Office PowerPoint 2007 to enable you to find and remove hidden data and personal information that is specific to each of these programs. The add-in processes the Item.Write event and cancels the operation. Perform SQL-like queries against the data. The user changes, for example, the item’s subject and clicks Save. To use the Document Inspector in Word after saving a copy of the original document, open the document to inspect. The add-in handles either the Inspectors.NewInspector or Inspector.Activate event to get a reference to the item displayed in the inspector. First, open the Office document you would like to protect. The user opens an inspector for an e-mail, appointment item, etc.