selection is grayed out on a shared doc

  • Thread starter Thread starter abailey
  • Start date Start date
A

abailey

Please Help!

I created a document, selected Protection>Protect Sheet, then made it
shared document. My problem is now the “Unprotect Sheet” selection i
grayed out and I need to make some changes. I am also unable t
unshare the sheet. I would appreciate any info on the issue.

Thanks in advance,
Ada
 
Adam

Go to Tools - Share Workbook and uncheck the "Allow changes..." checkbox.
That should re-enable Unprotect.
 
Thanks for the reply, but I tried that and it didn't work. The do
still remained in shared mode and I was unable to unprotect the doc.

-Ada
 
Adam

Odd. It worked for me in XL2000. I get a message about my change history
being erased. I click yes and the workbook is back to exclusive use. Do
you get a message when you try to "unshare" it? What version are you using?
 
Back
Top