View Single Post
 
Old 10-28-2016, 03:33 AM
Pierrot Pierrot is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Oct 2016
Posts: 1
Pierrot is on a distinguished road
Angry 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
Reply With Quote