View Single Post
  #1   Report Post  
mcwhirter
 
Posts: n/a
Default unprotect/protect grouped worksheets in excel

I have multiple sheets in multiple work books and want some to be protected
and others not. I wanted to break links to another work book but found that
the protected sheets would not allow it. I tried to group the sheets
together and then unprotect them but unprotect in the tools menu was greyed
out. How can I unprotect multiple work sheets? Very time consuming doing
this one sheet at a time for 100 sheets.