Unable to unprotect an Excel Worksheet
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 |
Unable to unprotect an Excel Worksheet
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 |
Unable to unprotect an Excel Worksheet
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 |
All times are GMT +1. The time now is 10:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com