Error on Close Without Save

[Susan in Houston]

I've written a spreadsheet that sometimes causes an error that shuts down Excel when the model is closed without saving. It doesn't always cause an error on no-save closes and never causes this error when saved while closing. Any ideas?

 

[Iridium]

What's your s/s do and what's the error message? Running any code? Bit more info if you please!

 

[Susan in Houston]

The model is a large workbook with 50+ sheets, a custom toolbar and numerous VB macros. There is an Auto-Close macro that removes the custom toolbar before closing.

The error message simply says "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience." Then the usual submit to Microsoft babble.

 

[Iridium]

Any of these hits from a search of the MS KB relevant?

Microsoft Excel for Windows has encountered a problem and needs to close (xl2k)

Post your Auto Close macro (or the relevant bits if it's a bit long)

 

[Susan in Houston]

Sub Auto_Close()
On Error Resume Next
Call RemoveCustomMenu
End Sub

and, to answer your next question:

Sub RemoveCustomMenu()
On Error Resume Next
CommandBars("2004 Marketing Plan Menu").Delete
End Sub

I have this same code in other spreadsheets with no problems.

 

[Iridium]

Not sure as i'm not really a VBA monkey.

For some general info check out http://j-walk.com/ss/excel/tips/commandbars.htm and see if any of that content helps - else post back!

 

[Susan in Houston]

Well, I followed through each of the links you posted and they appear to be dead ends.

For what it's worth, the first time I open Excel and close the file without saving, it generally works. If I reopen the file again and close again without saving, it seems to error on the 2nd and later attempts. I think I've seen it on other very large (3+ MB) spreadsheets as well. This leads me to believe it has something to do with available memory and is not specific to this model.