Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2015, 06:45 AM
bjsusol bjsusol is offline Macro button is not working for some users Windows 7 64bit Macro button is not working for some users Office 2010 32bit
Novice
Macro button is not working for some users
 
Join Date: Mar 2015
Posts: 3
bjsusol is on a distinguished road
Default Macro button is not working for some users

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?
Reply With Quote
  #2  
Old 03-17-2015, 01:01 PM
Snakehips Snakehips is offline Macro button is not working for some users Windows 8 Macro button is not working for some users Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 03-23-2015, 07:57 AM
bjsusol bjsusol is offline Macro button is not working for some users Windows 7 64bit Macro button is not working for some users Office 2010 32bit
Novice
Macro button is not working for some users
 
Join Date: Mar 2015
Posts: 3
bjsusol is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button to show userform suddenly stopped working jpb103 Word VBA 0 05-22-2014 06:05 AM
Macro button is not working for some users Custom outlook form not working for all users. Scoth Outlook 1 02-03-2014 11:49 AM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM
Users pane not working in OutLook 2010 balubeto Outlook 0 01-16-2011 04:30 AM
Macro Button B2W Excel 2 06-18-2010 09:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft