Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel VBA code won't run on some computers

Posted on 2015-01-21
4
Medium Priority
?
102 Views
Last Modified: 2016-02-21
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?
0
Comment
Question by:Perfishent
  • 3
4 Comments
 
LVL 18

Expert Comment

by:Simon
ID: 40563735
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?
0
 

Author Comment

by:Perfishent
ID: 40566739
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.
0
 

Accepted Solution

by:
Perfishent earned 0 total points
ID: 41467490
This was a Microsoft Update bug that has since been resolved.
0
 

Author Closing Comment

by:Perfishent
ID: 41474231
No one submitted a correct solution.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question