Protect / unprotect function

[sg]

I used the "Review/Protect" function to protect a workbook w/mulitple
worksheets. I am trying to edit some of the worksheets but the icon on the
ribbon is not available. How do I retrieve the option to the "unprotect"
option?

 

[ryguy7272]

Tools > Protection > Protect Sheet
Does that do what you want to do?


Regards,
Ryan---

 

[sg]

Hello ryguy7272...
Not really. After going back only a couple of the worksheets are protected
while others are not. However, the unprotect button is unavailable. Any
suggestions for both my issues?

 

[ryguy7272]

Hummm, I'm not sure I full understand your dilemma. You say 'only a couple
of the worksheets are protected'... Maybe you can give this a try:
Tools > Protection > Protect Workbook (or Unprotect Workbook)


Regards,
Ryan---