Microsoft Office Excel has encountered a problem and needs to close...

[Cristoforo]

Hi all,
I wrote a macro in Microsoft Excel 2003 SP3 and it perfectly works when I am in designing mode. If I save the file and close only the workbook (not the Excel itself) I can open it thousand times it works but if I close the Excel, too, then on the next opening a window pops up with the "Microsoft Office Excel has encountered a problem and needs to close..." message and Excel quits. If I start Excel after this and set the Macro Security to "High" then I can open my workbook without any problem. If I open the Visual Basic Editor and simple save my code, close the editor, set the macro security to "Low" and close Excel then my macro works perfectly again when I open the file (till I don't close the Excel) What can be wrong? Does anybody have some ideas how to solve it? Thanks!

[Bob Phillips]

Cross-posted at ExcelForum http://www.excelforum.com/excel-prog...-to-close.html

[Cristoforo]

Sorry, I have already removed it from ExcelForum

[Bob Phillips]

Removing it should not be necessary, just tell each forum when you cross-post so that people do not waste their time trying to solve a problem that may have been solved elsewhere, or have some insightful ideas there.

[Bob Phillips]

Not sure I will be able to help, but what is the offending code?