Hiding Control Toolbar Checkboxes

[Guest]

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

 

[Guest]

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:

 

[Ron de Bruin]

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