Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2003 macro generates compiler error on 2007 | Excel Worksheet Functions | |||
Compiler Error - Not an Appropriate Name | Excel Discussion (Misc queries) | |||
Compiler Error | Excel Discussion (Misc queries) | |||
Excel Compiler - is one available? | Excel Programming | |||
Compiler Error - Named Argument Not Found | Excel Programming |