View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Unvisible checkbox

Hi Madiya,

The default values for the checkbox's Visible and Enabled properties is
true.

However, the following works for me:

'=============
Public Sub Tester()
Dim SH As Worksheet

Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE

With SH.OLEObjects("Checkbox1")
.Visible = True
.Enabled = True
End With

End Sub
'<<=============

Post your problematic code.


---
Regards,
Norman



"Madiya" wrote in message
oups.com...
I am adding few checkboxes directly to the worksheet cell by toolbar
(control toolbox).
I have set the enable and visible property to true but still the
checkboxes are not visible.
I intend to assign a macro to each checkbox to carry out some
operations.

I have done it earlier but now cant figure out how to make it visible
permanantly.

Pl help.
Regards,
Madiya