Using Custom Views in a protected worksheet, the column hiding/unhiding implicit in the views does not occur. The following error message is displayed:
In the Add View dialog box, I've checked the "Hidden rows, columns and filter settings" option.
In the protection dialog box, I've checked the checkbox for "Format Columns", which I believe indicates that hiding/unhiding columns is permitted when the sheet is protected. And, when the sheet is protected, I can manually hide and unhide columns, but I want that to happen automatically when I select the custom view.
If I unprotect the worksheet, column hiding/unhiding occurs automatically when I select the custom view.
Can I write code to make the column hiding and unhiding occur when the view is selected, perhaps by unprotecting the sheet temporarily and then protecting it again once the selected view has been displayed?
Some view settings could not be applied
In the Add View dialog box, I've checked the "Hidden rows, columns and filter settings" option.
In the protection dialog box, I've checked the checkbox for "Format Columns", which I believe indicates that hiding/unhiding columns is permitted when the sheet is protected. And, when the sheet is protected, I can manually hide and unhide columns, but I want that to happen automatically when I select the custom view.
If I unprotect the worksheet, column hiding/unhiding occurs automatically when I select the custom view.
Can I write code to make the column hiding and unhiding occur when the view is selected, perhaps by unprotecting the sheet temporarily and then protecting it again once the selected view has been displayed?