In a protected worksheet I want to hide/unhide certain columns using Custom
Views. The column hiding/unhiding works fine as long as the worksheet is not
protected, but I get the following message and the columns are not properly
hidden/unhidden, when the worksheet is protected:

"Some view settings could not be applied".

I hoped that checking the checkbox "Format Columns" in the Protect dialog --
that is, allowing users to "format columns" when the sheet is protected --
would do the trick, but that does not seem to be the case. In fact, I tried
checking ALL THE CHECKBOXES and that did not allow hide/unhide columns. HELP
says:

"Format columns When cleared, prevents users from using any of the
commands on the Column submenu of the Format menu, including changing column
width or hiding columns."

The "Format Columns" DOES allow me to manually hide and unhide columns, even
when the sheet is protected, but it just doesn't happen automatically as part
of the Custom View.

Is there some other way to accomplish what I want?

I don't mind writing some code, but I'm unclear on where to put it. What
event or action would trigger just before a Custom View is carried out? Seems
I could turn off protection to let the Custom View hide/unhide the desired
columns. But then I would need to turn protection back on and I'm not sure
where/how that piece of code would get executed.

Any thoughts or suggestions will be appreciated.

TIA,

Phil