Unprotect sheet/workbook

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I protected the worksheets and the workbook. Now I need to unprotect them for
some changes, but on the review tab, unprotect sheet and unprotect workbook
is grayed out. I did not use any password. How can I unprotect this
workbook/worksheets.

Thanks,

Steve
 
Hi,


Maybe it's a shared workbook and if it is?

Unshare the workbook, unprotect, make your changes, protect and the re-share.

Mike
 
You most likely also shared the workbook under Tools>Share Workbook.


Gord Dibben MS Excel MVP
 
I can unprotect the shared workbook, but that doesn't enable the unprotect
sheet command ( it's still grayed out).
 
Do you have more than one sheet selected?

Do you see [Group] in the title bar?

This would gray out the unprotect sheet command.

Ungroup if that's the case.


Gord
 
No

Gord Dibben said:
Do you have more than one sheet selected?

Do you see [Group] in the title bar?

This would gray out the unprotect sheet command.

Ungroup if that's the case.


Gord

I can unprotect the shared workbook, but that doesn't enable the unprotect
sheet command ( it's still grayed out).
Click to expand...
Click to expand...
 
Ooops!

Misread the preceding reply about unprotecting the shared workbook.

As long as the workbook is shared, the unprotect sheet will remain grayed
out.

You must unshare the workbook to unprotect sheets.


Gord

No

Gord Dibben said:
Do you have more than one sheet selected?

Do you see [Group] in the title bar?

This would gray out the unprotect sheet command.

Ungroup if that's the case.


Gord

I can unprotect the shared workbook, but that doesn't enable the unprotect
sheet command ( it's still grayed out).

:

Hi,


Maybe it's a shared workbook and if it is?

Unshare the workbook, unprotect, make your changes, protect and the re-share.

Mike

:

I protected the worksheets and the workbook. Now I need to unprotect them for
some changes, but on the review tab, unprotect sheet and unprotect workbook
is grayed out. I did not use any password. How can I unprotect this
workbook/worksheets.

Thanks,

Steve
Click to expand...
Click to expand...
Click to expand...
 
Ok, thanks. Almost there. By unsharing the workbook, the protect workbook
became ungrayed, but unprotect worksheet is still grayed out. I feel so
stupid.
What I currently have in the Review that's grayed out is: Unprotect sheet &
Allow users to edit ranges.
The tabs not grayed out are: Protect Workbook, Share workbook, Protect &
Share Workbook & Track Changes.

Gord Dibben said:
Ooops!

Misread the preceding reply about unprotecting the shared workbook.

As long as the workbook is shared, the unprotect sheet will remain grayed
out.

You must unshare the workbook to unprotect sheets.


Gord

No

Gord Dibben said:
Do you have more than one sheet selected?

Do you see [Group] in the title bar?

This would gray out the unprotect sheet command.

Ungroup if that's the case.


Gord

I can unprotect the shared workbook, but that doesn't enable the unprotect
sheet command ( it's still grayed out).

:

Hi,


Maybe it's a shared workbook and if it is?

Unshare the workbook, unprotect, make your changes, protect and the re-share.

Mike

:

I protected the worksheets and the workbook. Now I need to unprotect them for
some changes, but on the review tab, unprotect sheet and unprotect workbook
is grayed out. I did not use any password. How can I unprotect this
workbook/worksheets.

Thanks,

Steve
Click to expand...
Click to expand...
Click to expand...
 
Back
Top