Hiding Control Toolbar Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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:
 
Back
Top