Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2016, 03:33 AM
Pierrot Pierrot is offline ActiveX is not activated when opening Excel2016 sheet Windows 7 64bit ActiveX is not activated when opening Excel2016 sheet Office 2016
Novice
ActiveX is not activated when opening Excel2016 sheet
 
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
Reply

Tags
activex, excel2016, togglebutton



Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX is not activated when opening Excel2016 sheet Open an existing sheet by clicking on a cell in a master sheet darbybrown Excel 3 09-12-2016 05:12 PM
ActiveX is not activated when opening Excel2016 sheet 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
ActiveX is not activated when opening Excel2016 sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft