Dim oleObj As OLEObject

Set oleObj = Worksheets("Sheet1").OLEObjects("CheckBox1")

oleObj.Visible = True ' or False
oleObj.Object.Caption = "New Caption"

Similar for the commndbutton

Regards,
Peter T


"kalle" wrote in message
...


Thanks på your answer.

It is the ActiveX control and it's checkbox and commndbutton.



*** Sent via Developersdex http://www.developersdex.com ***