Cristoforo
03-28-2012, 11:31 PM
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!
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!