![]() |
#1
|
|||
|
|||
![]()
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! |
Tags |
activex control, excel 2013, vba |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
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 |