View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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