none
On editing protected view using "ProtectedViewWindow.Edit", settings under "Display options for workbook" are getting changed. RRS feed

  • Question

  • When I call "ProtectedViewWindow.Edit" in "ProtectedViewWindowOpen" event, document gets open successfully without protected view but all settings under options-> Advanced -> "Display options for workbook" are getting unchecked automatically. 

    Example:

    Show sheets tabs, show vertical scroll bar and show horizontal scroll bar was checked before placing file on network drive. 

    After copying same file over network drive and opening it, "ProtectedViewWindowOpen" event gets triggered and since we have called "ProtectedViewWindow.Edit" in that event,document gets open successfully without protected view. (Expected Behavior).

                                                            But after "ProtectedViewWindow.Edit" call vertical scroll bar, horizontal scroll bar and sheets tab are missing. That is all the setting under  options-> Advanced -> "Display options for workbook" are getting unchecked automatically. Although there is no change in modification date / time of document. These settings doesn't get change on manually clicking on Enable Editing button, it only happens on calling "ProtectedViewWindow.Edit".

    Is there any way to edit protected view window programmatically without changing the display option.







    • Edited by Ankur_Singh Thursday, December 5, 2019 10:00 AM
    Tuesday, December 3, 2019 1:00 PM