Solved

Excel VBA code won't run on some computers

Posted on 2015-01-21
4
38 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adobe Acrobat Pro: how to copy style? 2 105
Open Office very very slow 3 137
Dialogbox API leak? 18 95
VIDEO DATASOURCE Control Resize issue 2 19
Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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 …

773 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