Excel Updates have stopped vba coding from working and control boxes (drop down lists)

On Dec. 16, 2014 we had some updates installed to our office suite and excel. Somehow one of these updates has screwed up our spreadsheets that have been working for years. It has been pinpointed to the update since we had some computers at our office that were not impacted because these updates had not been installed yet and a few other computers we could temporarily save by doing a system restore.

Anyway, we had controls that we drop down lists of names on a timecard spreadsheet that we could no longer select the drop down arrow no matter what I did. Tried with designer mode on and everything to no avail. Also, we have a few other workbooks with drop down controls and those stopped working across all the computers that updated. It also seems to have impacted some of our vba script on a few workbooks when it calls :
Private Sub Workbook_Open()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

or after open when I press submit on a macro controlled button an application defined or object defined error of:
ActiveSheet.Unprotect

and if I inactivate that it calls a method failed problem with:
Application.GoTo Reference:="DBHrs"

and it goes on and on from there.

I have tried to uninstall the individual excel updates that were put on that day, and that just screwed up excel and my computer and I reformatted so those individual updates must have not affected it, but there were many other suite updates (like 25). Right now I am telling people not to update their computers until we can get a handle on this. Any insight from you brilliant people out there would be greatly appreciated. We are using Excel 2010 in a Windows 7 environment.

Thanks

I think that may have fixed it. I performed the tasks on my computer and it works and now I am going to try some others.

Thanks!

Originally Posted by JieJenn

I think it was a known issue from the MS most recent update. Try the fix instructed on the website see if that solve your problem.
http://excelmatters.com/2014/12/10/o...ivex-controls/

I posted a thread earlier of a similar problem. If you scroll to the bottom of the link provided by JieJenn, a comment is made by David Fabian suggesting that if the update was done on computer A, then you try and run software from A on B, it will not work if B has not been updated. I installed the update on B and deleted the .exd files, rebooted and back to normal!

Thank you everyone. I think that this is now solved. All of our issues regarding the update have been resolved (for right now).

Thanks!