ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unable to Unlock Workbook (https://www.excelbanter.com/excel-worksheet-functions/260010-unable-unlock-workbook.html)

Adrian

Unable to Unlock Workbook
 
In my workbook it was password protected and able to be unlocked, now
when trying to unprotect it the option to unprotect is grayed out 3 other
clients are using this workbook and the option is grayed out for them as
well. One day it was fine the next day they couldnt access it.

How do I unprotect my workbook if the option to click is greyed-out?



Mike H

Unable to Unlock Workbook
 
Hi,

You will have to un-share the workbook then un-protect it.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Adrian" wrote:

In my workbook it was password protected and able to be unlocked, now
when trying to unprotect it the option to unprotect is grayed out 3 other
clients are using this workbook and the option is grayed out for them as
well. One day it was fine the next day they couldnt access it.

How do I unprotect my workbook if the option to click is greyed-out?




All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com