Link to home
Start Free TrialLog in
Avatar of Perfishent
PerfishentFlag for United States of America

asked on

Excel VBA code won't run on some computers

I have some VBA code that runs in a worksheet when a button is clicked. The code runs perfectly on some computers, but on others nothing happens when the button is clicked. I've checked the macro permissions and they are the same on all of the computers. I'm also aware of the issue with the Windows update that came out in December 2014. I've run the Fix It to no avail. http://support.microsoft.com/kb/3025036/EN-US

Is there a setting outside of the Trust Center settings that could be causing the issue? Is the Microsoft Fix It incomplete in some way so that it's not working on some computers?
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

Does the code run if you trigger it by another method? eg. by choosing the macro from the Macros menu? If so, it is very likely to be the ActiveX error.
Are you able to add a new button and associate the macro with it?
Avatar of Perfishent

ASKER

When I click on the Macros icon under the developer tab, it doesn't show any macros available to run. This is the case even on the machines where the code is running okay. On the machines where the code won't run, I've tried renaming the button and creating a new VBA subprocedure that responds to the button click. But the code still won't run.
ASKER CERTIFIED SOLUTION
Avatar of Perfishent
Perfishent
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No one submitted a correct solution.