Thread: Workspace
View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If the worksheet is protected, setting such as hidden columns can't be
applied. You could use a macro to unprotect, apply the view, and reprotect.


evander wrote:
I am trying to use custom views in a workspace that all of the worksheets
have been protected, but it says that some views are not available and will
not bring any views up. I was just wondering if anyone knew how to make
these custom views usable in the protected workspace because they worked
before I protected the worksheets.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html