Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel VBA code won't run on some computers

Posted on 2015-01-21
4
Medium Priority
?
83 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Photo Albums in PowerPoint Photo Albums are a very useful tool in PowerPoint and allow you quickly add a large number of images. The images can be formatted in a variety of ways so that you are able to create a professional looking presentation v…
With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

688 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