Macro button is not working for some users

[bjsusol]

Excel 2010 - Windows 7 64bit.



We received a spreadsheet from a client. This spreadsheet has a macro button in it that generates an email based on the filled out form.
It works perfectly for myself and several other users. However, for the group of users that need it, the macro button does nothing. I click it, and it generates an email properly. They click it, and nothing happens at all.

I went thru and compared their security settings in the trust center with my own, and we match up perfectly. None of us are admins on the machines and for the more part, our machines are identical in terms of software and patches.

Does anyone have any suggestions as to what might be blocking it for them? What other security could there be? The can work around it by logging into citrix where it DOES work for them.

Any thoughts?

[Snakehips]

bjsusol,

Might this be something to do with the Dec 2014 update issues?
Maybe some machines picked up the update and some didn't.

http://blogs.technet.com/b/the_micro...-updates-.aspx

I have experienced the issues of 'dead' existing ActiveX controls and the inability to insert new ones. All resolved using the below fix...


https://support.microsoft.com/en-us/kb/3025036/en-us

Hope that helps.

[bjsusol]

you nailed it.

I created a small script to delete the EXD files and its working now.

Thank you!

https://social.technet.microsoft.com/Forums/en-US/473b1980-56b3-49ff-be71-3a60c0db048b/form-controls-stop-working-after-december-2014-updates?forum=excel

https://technet.microsoft.com/en-us/library/security/ms14-082.aspx