ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to view a custom view when the worksheet is protected? (https://www.excelbanter.com/excel-worksheet-functions/75494-how-view-custom-view-when-worksheet-protected.html)

JulesJam

How to view a custom view when the worksheet is protected?
 
I have a worksheet and built custom views. The views work fine when the
worksheet is not protected. When protected and select a custom view, I get
this error message: "Some view settings could not be applied."

My protection settings allow the user to do all options, except: insert
hyperlinks, delete columns, edit objects and scenarios and use autofilter.

In the cell format (protection tab), I have also tried using the hidden
option.


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com