| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide check box
I am trying to hide an entire worksheet except for a certain range of cells.
The range that is unhidden changes depending on what is selected. The problem I have is the checkboxes in the range that I am trying to hide can't be hidden. Is there a property for them that will allow them to be hidden? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide check box
If your checkbox was created from the Control Toolbox toolbar (rather than
the Forms toolbar), you can hide it this way: - display the Control Toolbox toolbar and enter Design Mode (there's a Design Mode button) - right-click on the checkbox on your worksheet and select Format Control... - on the Properties tab, select "Move and size with cells" - hide the row(s) containing the checkbox, and it will be hidden also. Hope this helps, Hutch "ranswert" wrote: I am trying to hide an entire worksheet except for a certain range of cells. The range that is unhidden changes depending on what is selected. The problem I have is the checkboxes in the range that I am trying to hide can't be hidden. Is there a property for them that will allow them to be hidden? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide check box
"Move and Size with cells" is shown in the properties tab but I am not able
to select it. I can only select the other two options. "Tom Hutchins" wrote: If your checkbox was created from the Control Toolbox toolbar (rather than the Forms toolbar), you can hide it this way: - display the Control Toolbox toolbar and enter Design Mode (there's a Design Mode button) - right-click on the checkbox on your worksheet and select Format Control... - on the Properties tab, select "Move and size with cells" - hide the row(s) containing the checkbox, and it will be hidden also. Hope this helps, Hutch "ranswert" wrote: I am trying to hide an entire worksheet except for a certain range of cells. The range that is unhidden changes depending on what is selected. The problem I have is the checkboxes in the range that I am trying to hide can't be hidden. Is there a property for them that will allow them to be hidden? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide check box
That indicates your checkbox was created from the Forms toolbar. The forms
toolbar controls use less system resources but offer fewer features. You could delete your current checkbox and replace it with one from the Control Toolbox toolbar. Hutch "ranswert" wrote: "Move and Size with cells" is shown in the properties tab but I am not able to select it. I can only select the other two options. "Tom Hutchins" wrote: If your checkbox was created from the Control Toolbox toolbar (rather than the Forms toolbar), you can hide it this way: - display the Control Toolbox toolbar and enter Design Mode (there's a Design Mode button) - right-click on the checkbox on your worksheet and select Format Control... - on the Properties tab, select "Move and size with cells" - hide the row(s) containing the checkbox, and it will be hidden also. Hope this helps, Hutch "ranswert" wrote: I am trying to hide an entire worksheet except for a certain range of cells. The range that is unhidden changes depending on what is selected. The problem I have is the checkboxes in the range that I am trying to hide can't be hidden. Is there a property for them that will allow them to be hidden? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide check box
Check your other thread for suggestions.
ranswert wrote: I am trying to hide an entire worksheet except for a certain range of cells. The range that is unhidden changes depending on what is selected. The problem I have is the checkboxes in the range that I am trying to hide can't be hidden. Is there a property for them that will allow them to be hidden? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to Hide/reappear check boxes | Excel Discussion (Misc queries) | |||
| How do I hide the Check Box number? | Excel Worksheet Functions | |||
| Check Box to Show/Hide Columns | Excel Programming | |||
| Check Box Show Hide | Excel Programming | |||
| Want to hide check boxes | Excel Programming | |||
Hybrid Mode
