I have numerous worksheets I use in my job. I protect the data by protecting
the worksheet. I do not use a password for this. I have one workbook which
I cannot unprotect the sheet. When I click on tools, protection, the
unprotect button is grayed out and is not available as an option for me. Any
ideas how I can unprotect fix this?

Thanks

Hi,

My guess is that it's a shared workbook and you must unshare, unprotect and
re-share.

Mike

"lmckay" wrote:

I have numerous worksheets I use in my job. I protect the data by protecting
the worksheet. I do not use a password for this. I have one workbook which
I cannot unprotect the sheet. When I click on tools, protection, the
unprotect button is grayed out and is not available as an option for me. Any
ideas how I can unprotect fix this?

Thanks

Unshare the workbook?


Gord Dibben MS Excel MVP

On Wed, 22 Oct 2008 11:21:00 -0700, lmckay
wrote:

I have numerous worksheets I use in my job. I protect the data by protecting
the worksheet. I do not use a password for this. I have one workbook which
I cannot unprotect the sheet. When I click on tools, protection, the
unprotect button is grayed out and is not available as an option for me. Any
ideas how I can unprotect fix this?

Thanks