The Unprotect option is not available to me. Why? How to Get it Back?

[mimih23]

Hello!
My Unprotect button is grayed out for the worksheets that I just set up with a password to protect them. What could I have done for it to gray out completely? I have the password but I am not given the option to enter it!!! Ahhh! Help please!

"Remove protection from a worksheet

1.On the Review tab, in the Changes group, click Unprotect Sheet (gray!!!).

The Changes group on the Review tab

Note: The Protect Sheet option changes to Unprotect Sheet when a worksheet is protected."

 

[jtakw]

Hi,

It's possible you somehow "Grouped" the sheets.

Right click on any sheet tab, select "Ungroup Sheets"

 

[mimih23]

Hi,

It's possible you somehow "Grouped" the sheets.

Right click on any sheet tab, select "Ungroup Sheets"

Hey there!
Nope. No grouping!

 

[dickindeventer]

You dit not maybe protect the whole workbook also?

 

[mimih23]

You dit not maybe protect the whole workbook also?

That is correct. I did not protect the whole workbook. I have the first three tabs open while the rest password protected. Any thoughts?

 

[mimih23]

Solved the problem.

- Unshare the workbook by selecting "Share Workbook" under Review Tab

- In Editing tab uncheck "Allow changes by more than one user at the same time."

- Select "Unprotect Sheet" under Review Tab

- Provide password to unprotect sheet

 

[Pearly8]

Hi,

It's possible you somehow "Grouped" the sheets.

Right click on any sheet tab, select "Ungroup Sheets"

I just wanted to thank you for this - that's exactly what happened with a slip of typing somehow, to my spreadsheet. It was driving me crazy but I found your post and fixed it. I registered to this site just to thank you

 

[jtakw]

You're welcome, welcome to the forum.

Glad it resolved your problem, when you need any help in the future, feel free to start a thread for your question.