ActiveX and form controls stops working after formatting PC

[adorlytanglao]

I have some couple of functions/ macros on activex and form buttons. One function is to go to the last empty data on a column, and many others. I reformatted my PC, now the everything stops working. I understand that some files/softwares/updates were removed during reformatting I just cant tell which and how to reinstall it. For now i enabled the activex option on excel and restarted my PC, its still not working.

 

[vds1]

Try this resolution from Microsoft

Form Controls stop working after December 2014 Updates - The Microsoft Excel Support Team Blog - Site Home - TechNet Blogs

 

[adorlytanglao]

I tried deleting the .exd files it still didnt work. Also i found somewhere that deleting content in temp folder will do trick apparently it didnt. Im having an error 32809 upon compiling.

crosspost

ActiveX and form controls stops working after formatting PC

 

[vds1]

Not sure about that error.. here is the link regarding similar error..

http://www.mrexcel.com/forum/excel-questions/824156-activex-error-32809-a-2.html

 

[adorlytanglao]

The solution on that thread is to reinstall the OS. I want to try that but i just reinstalled the OS and im afraid the problem will just repeat. Because i think i reinstalled automatically with the latest copy of windows 7 and the updates that caused this is there.

 

[adorlytanglao]

For some reason i tried adding this step, i saved the file first into a regular excel workbook. Then save it again into macro enabled workbook. Don't know why but it works. In other word, the solution provided is correct. Others might need to add that step in case previous steps didnt fixed it.