excel locks up and crashes when adding new rows to a worksheet

[rabrown]

We are having problems with Excel 2003...

We have a spreadsheet that has macros and formulas in it. When you try to
add a new row, the excel locks up and crashes your computer. Does anyone
know why this happens and have any thoughts on how to fix it?

 

[Shane Devenshire]

Hi,

Probably related to the macros. Check by opening the file and not enabling
the macros (when security is set to Medium). If things work then you need to
look at your code.

 

[rabrown]

This is helpful, but I need more clarification )

I disabled the macros and the spreadsheet was functioning fine. However,
the person who created the file has already gone through and checked all the
code and tested it. The code seems to be working fine, yet many of us still
seem to be having problems.
Do you know of anything specific about the code that we should be checking?

 

[Shane Devenshire]

Hi,

Well it looks like you have located the problem. I would look for code in
the thisWorkbook object or in the Sheet1, Sheet2,... objects. In the VBE
double-click these objects in the Project Explorer. Check each for code.
Also, you may want to note if there are any other projects listed in the
Project Explorer other than the one file you have open.