ActiveX is not activated when opening Excel2016 sheet
Hello.
With previous Excel2007, my 15 ToggleButton were working well.
Since I'm using Excel2016, it's not working anymore.
With a simple test sheet, it's working, so I save it.
Then when I open this test sheet, it's not working.
I have authorised all ActiveX parameters in /Options.
You can try this, and in response (if it works), send your parameters :
Private Sub ToggleButton1_Click()
If ToggleButton1 = True Then
Range("A1").Select
Selection.Interior.Color = 65280
Else
Range("A1").Select
Selection.Interior.Color = 16777215
End If
End Sub
Thx
|