ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   When I open a workbook, cell protection is not fully active (https://www.excelbanter.com/excel-worksheet-functions/219047-when-i-open-workbook-cell-protection-not-fully-active.html)

Dave_B_at C&W

When I open a workbook, cell protection is not fully active
 
I have activate worksheet protection that prevents selecting "Protected"
cells, but when I open the workbook again, I can still select the cells but
just not change them. If in uprotect and reprotect the worksheet, I am then
not able to select the protected cells.

I only have the "select uprotected cells" option ticked when activating the
protection.


All times are GMT +1. The time now is 04:43 PM.

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