Forum Discussion
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 macro may not be available in this workbook or all macros may be disabled." I get the same result no matter which macros I run.
Checking the VBA editor, all macros are present in the document. VBA routines don't run via the editor. The "Design Mode" control is yellowed out and gives me the same kind of protection message when clicked.
I checked the permissions in the Trust Center and trusted locations only to find they are still the same as they have been for the past years. I also search the Windows 10 settings to see if there is another setting which might be new to this upgrade. I find none.
Any suggestions?
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
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.
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.
