Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-10-2014, 06:49 AM
Johauuez Johauuez is offline ActiveX controls on Worksheet stopped working Windows 8 ActiveX controls on Worksheet stopped working Office 2013
Novice
ActiveX controls on Worksheet stopped working
 
Join Date: Dec 2014
Posts: 4
Johauuez is on a distinguished road
Question ActiveX controls on Worksheet stopped working

Hello,

In my company we have several PCs running Windows8.1 with either Office 2010 or 2013.

We use multiple Excel files with ActiveX buttons on the spreadsheet to activate Macros that mainly import data from .txt files.
Without any major problems with our current setup(all day, daily, for approx 6 months now)

Today, one of the PCs (W8.1, Excel2013) suddenly did not recognize the ActiveX buttons on the spreadsheet as buttons. I just can't click on them anymore, they seem frozen.
The macro itself that the button is linked to, works.
If I try to add an ActiveX CommandButton, I get an error:
"Cannot insert Object".
However, the FormButtons still work, and I can add more of them.
This problem occurs with any excel file. That is the case even when I make a completely new book.

I tried setting the Macro and ActiveX safety settings to the lowest in [File-Option-Security Center Settings-(ActiveX/Macro Settings)]
But no change.
I am not in Design mode. (If I go into design mode, I can select the buttons, and with a double click I can open the Code editor. However, the cursor does not jump to the part of the code it should jump to, and I can also not see the properties with a right click on the button -it shows the properties of the sheet instead)

A few hours later, the next PC (W8.1, Excel2010) stopped working. Exactly the same issue. And this PC did not open a file the first PC had opened or created...

2 out of 5 PCs stopped working, the last 3 still work.
I tried reproducing the problem with one of the working PCs, but I couldn't.

I couldn't find a thread anywhere with someone having the same issue, so I made one myself.
Do you have any suggestions????

It's frustrating me...


Thank you so much for your help!
Reply With Quote
 

Tags
activex control, excel 2013, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save to PDF stopped working RzB Excel 6 06-26-2014 03:40 AM
Outlook stopped working CarolVee Outlook 0 07-21-2013 10:47 AM
ActiveX controls on Worksheet stopped working Word stopped working judyn Word 5 10-18-2012 03:09 PM
Need help with placeholder text in ActiveX controls in Word mhellerstein Office 0 11-02-2011 12:31 PM
ActiveX controls inserted on a template do not function well ged Word 0 10-21-2010 04:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


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