ExcelBanter - Why is the option to unprotect a worksheet 'grayed out'

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why is the option to unprotect a worksheet 'grayed out' (https://www.excelbanter.com/excel-discussion-misc-queries/115424-why-option-unprotect-worksheet-grayed-out.html)

rook

Why is the option to unprotect a worksheet 'grayed out'

What can I do to rectify this situation.

Jim Thomlinson

Why is the option to unprotect a worksheet 'grayed out'

As a guess your workbook is shared. You can not unprotect a sheet on a shared
workbook. If you need to do that you will have to unshare the book first.
--
HTH...

Jim Thomlinson

"rook" wrote:

What can I do to rectify this situation.

All times are GMT +1. The time now is 07:57 PM.