ProtectedViewWindow.Workbook property (Excel)

Article
09/13/2021

Returns an object that represents the workbook that is open in the specified Protected View window. Read-only.

Syntax

expression.Workbook

expression A variable that represents a ProtectedViewWindow object.

Return value

Remarks

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 the Workbook method will be limited. Any operation that is not allowed will return an error.

A workbook displayed in a Protected View window is not a member of the Workbooks collection. Instead, use the Workbook property to access a workbook that is displayed in a Protected View window.

Example

The following example uses the Workbook property to return 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Share via