Forum Discussion

Copper Contributor

Dec 21, 2017

Excell Changed after Update version 1703 for Windows 10 - Macros no longer run

I am using Excel 2007. This morning I installed the Windows 10 upgrade 1703. Now the VBA in my Excel spreadsheets is blocked from running. I get the message "Cannot run the macro 'macro name'. The ma...

Macros & VBA

Need Help

Mark Fitzgerald

Iron Contributor

Dec 22, 2017

If you have already rebooted you could try:

Check for any missing references in VBA Tools -> References
Make sure your PERSONAL workbook is saved in .xlsb format
Repair Office

Ken Kolkebeck
Copper Contributor
Dec 22, 2017
The reference file has these items checked; VB for Applications, MS Excel 12 Obj Lib, OLE Automation, MS Office 12 Obj Lib, and MS XML, v6.0. Seems like all the excel applications are covered. Then there is the Personal.xlsb file. I did not have one so I created one. Macro loaded in it runs fine, but my others do not.

None of this worked. I'll try the repair.
- Ken Kolkebeck
  Copper Contributor
  Dec 22, 2017
  The repair did not work. I did get an error on a missing PIA but I see the association is with outlook which I do not use. I keep thinking it is a setting I am missing.
  - Mark Fitzgerald
    Iron Contributor
    Dec 22, 2017
    I'm in uncharted territory now.
    
    It seems strange that you can run the macro in PERSONAL.xlsb but no others.
    
    If you can get into one of your non-functioning projects, try compiling it and see what happens.
    
    Also check your ActiveX settings in the trust centre.