Apr 01 2019 09:12 AM
Apr 01 2019 09:12 AM
I inherited two Excel files that come with a bunch of ActiveX buttons.
In some cases the buttons don't do anything: I click them, it shows kind of a duplicate image of the button on the side when I press the button, but nothing happens. The macro associated runs well if I run it from the VB Editor.
On the other file, the buttons do work but only when I click them for the second time. Any idea what may cause this to happen?
Thank you in advance for any tip or guidance.
Apr 01 2019 11:36 PM
Jul 02 2019 05:02 PM
Jul 03 2019 04:11 AM
Nov 18 2019 05:18 AM
oi tudo bem @Celia_Alves I have this issue too. I don't think it's W10 per-se as they were fine until recently - so it's something to do with a recent update I would say. I did look at replacing them with ordinary buttons but there was some disadvantage to that - which I can't recall right now. I'll try the "delete and replace with new" approach to see if that works, though, even if it does, it's hardly satisfactory. I don't recall a recent update coming with a disclaimer from MS saying that activeX macro buttons may not work (properly) anymore (mind you I expect what the small print actually says is that if their update causes Armageddon it's still not their fault!).
Nov 18 2019 05:21 AM
Nov 18 2019 05:27 AM
Nov 18 2019 05:44 AM
Nov 18 2019 05:48 AM
Nov 18 2019 05:51 AM
Nov 18 2019 07:55 AM
Nov 18 2019 08:19 AM
Nov 18 2019 09:52 AM
Nov 18 2019 06:56 PM
Nov 19 2019 03:28 AM
Nov 25 2019 01:04 PM
If you have any other ideas, I would appreciate hearing them. I've described everything I can think of that is relevant below.
ActiveX buttons that used to work on a single click now required two clicks to activate the macro. The buttons worked fine on my previous machine which was, as far as I can tell, identical. I have dozens of spreadsheets that are affected, each spreadsheet has many buttons (15-20) so I can't replace the buttons on each one. The functionality is occurring on two machines in my department (of 4), both recently configured. The problem does not occur on the other two (older) machines in my department. The other machine in my department that has problems is a Lenovo T570.
Things I have checked for my machine:
- Hardware: Microsoft Surface model 1769
- Operating system: Windows 10
- Microsoft Excel for Office 365 MSO (16.0.12026.20344) 64 bit (previous version was 64 bit “Microsoft Excel for Office 365 MSO (16.” but I can’t prove the exact version).
The functionality is the same whether the file is opened from a SharePoint (SP) web page, a local synced folder, or on the local HD (not synced).
Two single clicks cause the macro to activate on the second click. The second click can be separated from the first by anything up to 1 minute (didn't wait any longer). If the cursor leaves the button between clicks, then it is as if the button has not been clicked. Similarly, a single click, switching windows (Alt-Tab) switching back and clicking again acts the same as a single click (does nothing).
Double clicking the button is no different than single clicking. The two clicks must be separated by at least 1 second.
The problem occurred before I installed many of my custom programs so they should not be the issue.
I noticed the problem on the first day I used a spreadsheet with an ActiveX control. The problem has continued on subsequent days despite reboots and cold starts (over 2 weeks now).
I followed the directions above, I tried:
- deleting \AppData\Local\Temp\Excel8.0\MSForms.exd and then re-running Excel.
- deleting MSForms.exd, rebooting, and then re-running Excel.
- deleting everything I could delete in …\AppData\Local\Temp\*.* including sub folders, rebooting, and then re-running Excel.