hide check box

[ranswert]

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

 

[Tom Hutchins]

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]

"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.

 

[Dave Peterson]

Check your other thread for suggestions.

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

 

[Tom Hutchins]

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