Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spell Check Unlocked Cells Only | Excel Discussion (Misc queries) | |||
Protecting Check Boxes to prevent editing | Excel Discussion (Misc queries) | |||
Can you spell check protected but unlocked cells in excel2000? | Excel Discussion (Misc queries) | |||
Cells become unlocked and visible using a check box | Excel Discussion (Misc queries) | |||
Spell Check an Unlocked Cell in a Protected Spreadsheet | Excel Worksheet Functions |