Microsoft Excel - ActiveX controls do not run the marcos

The controls worked fine two days ago and now "nothing" happens.

This not the “object cannot be inserted”.
That problem is fixed by deleting the .exd files.

I do not get an error message, it’s simply,,,,,,,,, nothing happens

I can copy the  macro into a Module and run it by clicking on it, but the ActiceX button will not run it.

I can record new macros and they will run, but not with an ActiveX control

The spreadsheet is .xlsm Macro security is Enable all macros”

If I create a new ActiveX button, paste the code that works in the Module, the Control will not run it.

Also,,,,,, when I go into design mode and double click the existing button, it create and Private Sub. It does not refer to the original Sub.

Any help is greatly Appreciated.
Dennis

Hello Dennis,

Have you checked your Trust Center settings.

File>Options>Trust Center>Trust Center Settings>ActiveX Settings  and then ensure that an appropriate trust setting is checked (possibly Disable all controls without notification has been selected).

Regards

Harry

Harry,
Thx for the reply.

I did what you suggested. I have to admit, I've never been there before.

The setting is:
 - the bottom radio button, Enable all controls without restriction,,,,,,,,,,,,,,,,,,,,,

I looked in all the other settings and everything is set to Enable or Allow or Show or Prompt,,,,, etc.
I did not see anything that would stop a Control from running a Macro.

I appreciate you help, but sry to say, I need more help.

Again, thx,
Dennis

Hello again Dennis,

Perhaps if you can post a copy of a spreadsheet with a non-functioning control it might be possible to work out what might be going on.

Harry

Back at ya Harry!!!!

Inventory-v9-1 - Copy.zip

Again, thx for time,
Dennis

Raise you five, Dennis!

Hate to tell you this but it is obviously something specific to your computer as both control do exactly what they are supposed to on mine.

You have obviously done some research and tried some things but have a look at this link, there are a few ideas there that you might like to try or might be better explained than I could.  Let me know how you go.

http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled

Regards

Harry

Hi Dennis,

I know this sounds crazy, but have you

a) closed Excel entirely and re-opened it?
b) turned off your computer and re-booted (cold boot)?

Harry

Yep, tried the cold boot.

I have the same problem on my home desk top, my oggice desk top and my laptop.
I created another workbook and t runs fine, but I still cannot get this one to work.

After your email with regards to it working, I opened the file I sent you and "now" I get (see attached)

Capture.zip

hmmmmmm,

Hi Dennis,

What is it that you are getting that you didn't get before?

Harry

Harry,
Shortly after I sent you the file I began to get an error message:

  "cannot exit design mode, commandbutton1 cannot be created"

I have since created a new workbook, new code and I did not copy and paste anything from the contaminated workbook and it's working as planned.

This is strange, I'm guessing some kinda of virus, scan says none found, but
I deleted the bad workbook.
However I do have another workbook (attached) with the same problem, I have not yet done anything with that workbook.
Grinding-v1.zip

Also strange, the problem was on three of my computers and the same file works on yours.
See if this one works on your computer.

Again,,,,,, big thx for your time and effort!!!
Dennis

Hello Dennis,

The controls certainly seem to do something as the grey outline shape moves in relation to the red 'cross-hairs' and the text changes but I don't see any signs of rotation which is sort of implied by the context.

Is that what you would expect?

Harry

Harry,

It's working better for you than it is for me.

I assuming your are pressing the Roation Button and it is not working?
If that's the case, there is probably somethnig wrong with the code, but it work seemlessly before.
Are the other three buttons doing something, the x, z, return buttons?

One article I read with regards to Excel problems stated, some begin after updates. I 'm not sure that is the case here and even if it is, I do not have any idea how to correct it.

One thing in common with these two wookbooks is, I open and run them both on my home computer and another computer at the shop.

Thx,
D

Harry,

I have serveral backup drives. I went back through a couple of them, no luck. I jumped to the oldest, from a few weeks ago and both problem files work as designed on my home desktop and laptop. I will not be able test them at the office until Tues/Wed.

It has to be something with the files and I'm guessing it came from my office computer. We get alot of junk email from all over world promising everything.

I use Norton both places and I ran a scan here last night it came back clean. Nothing has been caught at the office, but that's my guess.

I'll probably rebuild my office computer and change email addys.

I'll keep you posted and again, thx,
Dennis

Harry,
I took the files that worked on my home pc and they did not work at the shop.
I restored and earlier v of ghost and all is working.

My beleif is that I received a virus thru email.
We'll never know for sure, but I'm not going to use my old email addy.

Again, a sincere thank you for your help,
Dennis

In case you're not aware

that there was a bug in one of Microsoft Security update.

Have a look at these link.

MS14-082: Description of

the security update for Microsoft Office 20XX: December 9, 2014:  

http://support.microsoft.com/en-nz/kb/3025036/en-us

vba - Microsoft Excel ActiveX Controls Disabled?

- Stack Overflow:

http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled

One more

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx



"It was KB2553154. Microsoft needs to release a fix. Pull off KB2553154

Design Mode.zip

Well,,,,,,,,,,,,,,,,
That is not the fix.

KB2553154 was on my office computer, which is where the problem starts, but even after deleting it and deleting all the .exd files, I still have the problem.

I can opena file and it works fine. I make changes and the changes work fine. I can close and reopen and the file works, for a while.

Then I get the attached message.

When I double click on CommandButton1, VB opens and the cursor is in CommandButton3. The CommandButton1 code is still there, but the button will not access it.

I can copy and paste the code from CommandButton1 into CommandButton3 and button will work. If I delete the code and CommandButton1 and try to renname CommandButton3 to 1, i get Ambiguous name found.

The files work on other computers, until I open and save them on my office computer. After opening and savings on my office computer, the same problem is on all computers.

Luckily, the problem has not transferred to my other computers,,,,, well, yey anyway :(

As alwys thx,
Dennis

Hello Dennis,

Definitely sounds strange given that your 'non-working' files are absolutely fine for me.  I could find no evidence of the update that John mentions on my computer which is perhaps a bit odd as I have automatic updates happening all the time.

I have done some fiddling around with CommandButtons and get the message about Ambiguous names only if there is another CommandButton1 on the sheet.  Having one on another sheet does not matter.

So, either there is a phantom CommandButton1 on your sheet or you only think you are deleting CommandButton1.  When you bring up the Properties interface, the critical one is the one at the top of the list (labelled (Name)).  perhaps go through all of the buttons on the sheet and just check what the (Name)(s) are to be sure.

One other possibility is that the offending control is a phantom and has been hidden at some stage by a macro that broke and has not been unhidden subsequently.  Have a look at this page for ways to investigate that.  You could probably cut down the list to only look for Controls.

http://excel.tips.net/T002025_Unhiding_or_Listing_All_Objects.html

This might not help you with the basic problem but if there are phantom controls lurking it could have some strange effect.

Regards

Harry

Harry,
Good thought, but when you go into Design Mode, any hiden buttons will show on the worksheet. None there :(

Also, this only happens when I open and save on my office computer. Then, sometimes it doesn't start for minutes or hours or maybe even a day, but it will start. That's why sometimes I feel I have it corrected, then I bring my stick home and it start here. It's also happened,,,,,,,,, I'll go to lunch, it's working fine, I come back and ng.

I have a hard time beleiving it's a virus, but who knows.
I'm leaning toward a Microsoft SNAFU!!!!

I feel the only way out of this is to rebuild my office computer. I have the orginal Windows 7 disk and key. So, off to the races.
I'll keep you posted, thx,
D