ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting,Unlocked,&Check Boxes (https://www.excelbanter.com/excel-programming/351672-protecting-unlocked-check-boxes.html)

Mon

Protecting,Unlocked,&Check Boxes
 
Hi Everyone
I have a report that I am working on that has three check boxes. Certain
cells are hidden until the appropriate check box is checked (i.e. - check box
1 unhides columns A to J rows 11 to 21, check box 2 unhides columns A to J
rows 22 to 30, and check box 3 unhides columns A to J rows 32 to 40). I have
this worksheet protected as well as only the cells I want our employees to
tab to (unlocked). However, when I try to choose a check box when the sheet
is protected the cells that are unlocked so you can tab to them - I get an
error... or it says something about a "bug" ??? I don't get what I'm doing
wrong? Do I need a code for this?
I'm pretty new to all of this code writing and stuff like that, so ANY help
would be GREATLY appreciated.
Thanks!


All times are GMT +1. The time now is 07:53 PM.

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