MWE,

Sounds like one of the VBA DLL files got corrupted. I'd uninstall
then reinstall.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MWE " wrote in message
...
About an hour ago, Excel started crashing when ever a VBA
compiler error
was encountered. I did a little testing and the following
happens
every time
1. there is a problem in a macro, could be as simple as a
misspelled
variable (Option Explicit is "on")
2. when the macro compiles, it stops at the problem and
displays the
normal ambiguous error mesaage
3. I look at the error and fix it (or not, does not matter)
4. I exit the VBE and get the message that this will stop the
debugger
5. I click OK and Excel crashes about 5 seconds later with the
wonderful "Microsoft Excel for Windows has encountered a
problem and
needs to close"

Once I have this crash, many other things cause a similar
crash, e.g.,
just closing a spreadsheet. If I reboot, I can do normal
things, but
if I have a VBA compiler error, the process starts again.

Does anyone have any idea what is going on here?

Thanks


---
Message posted from http://www.ExcelForum.com/