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
|