ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unprotect check box in protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/109538-unprotect-check-box-protected-worksheet.html)

Laura Bennett

unprotect check box in protected worksheet
 
I have a protected worksheet that has checkboxes (set up using validation
option). I have unchecked the locked feature in the protection tab for the
check boxes but they are still coming up as protected when I protect the
sheet.

What am I missing?

Dave Peterson

unprotect check box in protected worksheet
 
I'm not sure what "set up using validation option" means, but if you have a
linked cell that is locked on a protected worksheet, you'll have trouble.

Try unlocking that linked cell.

Laura Bennett wrote:

I have a protected worksheet that has checkboxes (set up using validation
option). I have unchecked the locked feature in the protection tab for the
check boxes but they are still coming up as protected when I protect the
sheet.

What am I missing?


--

Dave Peterson


All times are GMT +1. The time now is 03:15 AM.

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