Perfishent
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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No one submitted a correct solution.
Are you able to add a new button and associate the macro with it?