Represents a Protected View window.
A Protected View window is used to display a workbook from a potentially unsafe location. Unsafe locations are defined as the following:
- Files opened from the Internet.
- Attachments opened from Outlook.
- Files blocked by File Block Policy.
- Files that fail Office file validation.
- Files explicitly opened in Protected View by using the Open in Protected View command of the Open button in the Open dialog box.
Workbooks displayed in a Protected View window cannot be edited and are restricted from running active content such as Visual Basic for Applications macros and data connections. For more information about Protected View windows.
Files from the Internet and from other potentially unsafe locations can contain viruses, worms, or other kinds of malware that can harm your computer. To help protect your computer, files from these potentially unsafe locations are opened as read only or in Protected View. By using Protected View, you can read a file, see its contents and enable editing while reducing the risks.
To return a single ProtectedViewWindow object from the ProtectedViewWindows collection, use ProtectedViewWindows (index), where index is the index number of the window that you want to open.
You can also access the ProtectedViewWindow object that represents the active Protected View window by using the ActiveProtectedViewWindow property of the Application object.
After you access a ProtectedViewWindow object, use the Workbook property to access the Workbook object that represents the workbook file that is open in the Protected View window. Because a Protected View window is designed to protect the user from potentially malicious code, the operations that you can perform by using a Workbook object returned by a ProtectedViewWindow object will be limited. Operations that are not allowed will return an error.
The following code example accesses the Workbook object that represents the workbook that is open in the first Protected View window.
Dim wbProtected As Workbook If Application.ProtectedViewWindows.Count > 0 Then Set wbProtected = Application.ProtectedViewWindows(1).Workbook End If