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
|