Within Excel I have three frames, one of these frames contains check boxes. Based upon user selection, I want to be able to enable and disable these ActiveX check boxes, assuming that enabling/disabling the frame would be the most efficient way of doing this I tried the following code:
Dim oOle As OLEObject, ws As Worksheet
For Each ws In Worksheets
For Each oOle In ws.OLEObjects
oOle.Enabled = False
Next oOle
Next ws
But this disabled all the frames whereas I only want to disable Frame2
, can someone please help?
Aucun commentaire:
Enregistrer un commentaire