View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MWE[_12_] MWE[_12_] is offline
external usenet poster
 
Posts: 1
Default VBA Compiler Error Cause Excel to Crash

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/