#1
|
|||
|
|||
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 |
Tags |
activex, excel2016, togglebutton |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Open an existing sheet by clicking on a cell in a master sheet | darbybrown | Excel | 3 | 09-12-2016 05:12 PM |
UserForm textbox exit event activated with navigation buttons...why? help? | orozvik@yahoo.com | Excel Programming | 2 | 05-08-2015 02:50 AM |
Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
Help Coloring a cell in Sheet one if data is missing from another sheet | Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
Hyperlink not activated by footpedal | Donone | PowerPoint | 2 | 05-05-2014 04:42 AM |