none
How do I get out of a file in protected view? RRS feed

Answers

  • Hi mcfake,

    This forum is for developers discussing specific developing issue relative to VSTO.

    As far as I know, there are two ways to exit the protect view like below:

    Exit Protected View and edit when the yellow Message Bar appears

    • On the Message Bar, click Enable Editing.

    <section class="ocpSection">

    Exit Protected View and edit when the red Message Bar appears

    1. Click File > Edit Anyway.

    You can get more detail about protect view from link below:
    What is Protected View?

    And if you have any other end-user issue, I suggest that you reopen a new thread in Excel IT Pro discussions forum.

    Regards & Fei

    </section>


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 11, 2015 3:28 AM
    Moderator
  • Hello,

    The ProtectedViewWindow class 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, see What is Protected View?

    To return a single ProtectedViewWindow object from the ProtectedViewWindows collection, use ProtectedViewWindows(Index), where Index is the index number of the window 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 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.

    There is no method for unprotecting workbooks programmatically. You can just to re-open  files anew.

    Friday, December 11, 2015 12:49 PM

All replies

  • Hi mcfake,

    This forum is for developers discussing specific developing issue relative to VSTO.

    As far as I know, there are two ways to exit the protect view like below:

    Exit Protected View and edit when the yellow Message Bar appears

    • On the Message Bar, click Enable Editing.

    <section class="ocpSection">

    Exit Protected View and edit when the red Message Bar appears

    1. Click File > Edit Anyway.

    You can get more detail about protect view from link below:
    What is Protected View?

    And if you have any other end-user issue, I suggest that you reopen a new thread in Excel IT Pro discussions forum.

    Regards & Fei

    </section>


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 11, 2015 3:28 AM
    Moderator
  • Hello,

    The ProtectedViewWindow class 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, see What is Protected View?

    To return a single ProtectedViewWindow object from the ProtectedViewWindows collection, use ProtectedViewWindows(Index), where Index is the index number of the window 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 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.

    There is no method for unprotecting workbooks programmatically. You can just to re-open  files anew.

    Friday, December 11, 2015 12:49 PM