Hiding Control Toolbar Checkboxes
 

Hi there --

I am using checking boxes created from the Control Toolbar. In one version
of my spreadsheet, I need to hide the columns in which the checkboxes reside.
When I hide the columns, the checkboxes still appear. Any thoughts?

Thanks much.

Ellen

Hiding Control Toolbar Checkboxes
 

Sub tst()

Sheets(1).Shapes("CheckBox1").Visible = False
'Sheets(1).Shapes("CheckBox1").Visible = True

'or

'Sheets(1).Shapes.SelectAll: Selection.Visible = False

End Sub


"Ellen G" skrev:

Hi there --

I am using checking boxes created from the Control Toolbar. In one version
of my spreadsheet, I need to hide the columns in which the checkboxes reside.
When I hide the columns, the checkboxes still appear. Any thoughts?

Thanks much.

Ellen

Hiding Control Toolbar Checkboxes
 

Hi Ellen

Right click on the control and choose Format control
On the Properties tab you can change it to "Move and size with cells"

If you want to hide them with code see
http://www.rondebruin.nl/menuid.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ellen G" wrote in message ...
Hi there --

I am using checking boxes created from the Control Toolbar. In one version
of my spreadsheet, I need to hide the columns in which the checkboxes reside.
When I hide the columns, the checkboxes still appear. Any thoughts?

Thanks much.

Ellen