ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lock cells in a shared workbook (https://www.excelbanter.com/excel-discussion-misc-queries/251008-lock-cells-shared-workbook.html)

Jennifer

Lock cells in a shared workbook
 
I have a workbook that I have shared among a group of people. I would like
to be able to "lock" certain cells but it is not allowing me to enter in
protection after I share and protect. Is this possible?

Jim Thomlinson

Lock cells in a shared workbook
 
Nope... You can not change the protection on a shared workbook without first
unsharing it. In Help type in Shared workbook restrictions to find a complete
list of the features that are unavailable...
--
HTH...

Jim Thomlinson


"Jennifer" wrote:

I have a workbook that I have shared among a group of people. I would like
to be able to "lock" certain cells but it is not allowing me to enter in
protection after I share and protect. Is this possible?



All times are GMT +1. The time now is 09:20 PM.

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