Unprotect sheet/workbook

[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

 

[Mike H]

Hi,


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

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

Mike

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Steve]

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

 

[Gord Dibben]

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

 

[Steve]

No

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).

 

[Gord Dibben]

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

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

 

[Steve]

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.

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

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