Excel 2007 crashes upon saving

**JM967** · 06-23-2013, 06:27 PM

Hello all,
I have been programming with VBA on Excel 2007 for fun for some time.

I was looking around at my code, clicked the save button, and then closed the "view macro" box. Out of the blue, excel immediately crashed with the "excel is not responding" message.
Now, whenever I try to save the worksheet, Excel crashes. If I don't do anything but try to close the worksheet, every button in excel is grayed out and the grid is completely black. The only button that works is the top-left circular button, but all options there are greyed out. The only way to immediately close the worksheet is to go into Task Manager, Process, and kill the EXCEL.EXE process.
This came out of the blue, and I've been searching online for a while trying to solve this problem. I have yet to find anything conclusive...

**abousetta** · 06-23-2013, 06:51 PM

When freaky things like this happen, especially when debugging, I tend to close all instances of Excel from the task manager (there may be more than one still there from previous sessions). If this doesn't work, I restart the computer. If still no go, I copy all the vba code to a text files and recreate a new workbook. If still the problem doesn't go away then I circulate the workbook and ask for help as the problem may actually be with my installation of Excel, windows, etc.

Try and let us know.

abousetta

**MarvinP** · 06-23-2013, 07:03 PM

Hi JM,

I remember getting problems like this when in debug mode and stepping through code. If the code is stopped many of the icon's are grayed out. I've also done stupid things like stopped allowing events or screen updates with the code and things don't work. Look for Application.ScreenUpdates = False and Application.AllowEvents = False to insure you are back to normal, before trying to continue on.

If it looks like a "Save" is the problem, perhaps you are tying to save to an invalid location. Look in your code for this type of problem also.

Hope this helps.

**JM967** · 06-23-2013, 07:10 PM

Restarting my computer did not work, and I saw no other instances of excel in the task manager.
I did, however, copy my original macros into a word document and pasted them in to a new, blank workbook.
Fortunately, excel didn't crash, so I think it might be the worksheet itself.
I did have a good collection of cells colored, and quite a few pictures as well.
The worksheet document does take a while to load up, as well.

Thanks to all who have responded with suggestions!

**abousetta** · 06-23-2013, 08:40 PM

When you don't want to lose the cell formatting, etc., but remove all the macros, you can save the macros (as you did) in text format in a word editor and then save the excel file as .xlsx. This will strip it of all vba macros and code. Then you can try to re-create the modules, userforms, etc. It sometimes works. Another thing that has worked in the past is to decompile/ decompress/ recompile the vba code. MVP Orlando has a free program I use to do this.

Hope this helps.

abousetta