Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel VBA code won't run on some computers

Posted on 2015-01-21
4
Medium Priority
?
92 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Integration Management Part 2

927 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