Macros Written in Excel 2003 Problems in Excel 2010

For my sins I am Chairman of a local voluntary organisation. We have 300 + members which we have to keep details for, and I with the help of members of the forum back in 2003 I created and Excel workbook that did everything we needed it to do.

This includes changing the case etc of a members details are entered and extrapolating five sets of data on to seperate sheets and mail merges into word.

Some macros are embedded on the actual worksheet others are stored in the file as modules and are run from button macros.

Anyway this all worked fine until I got Excel 2010. It just doesn't like something about the workbook.

I have saved the file as an old format workboook, and new format workbook, a macro enabled workbook and I have problems with all of them.

Usually Excel stops responding and I have some weird behaviour in that I can't delete a row, but if I put the workbook on an old computer I can. I just can't work it out and it's very frustrating. I can't post the workbook because all of the data is sensitive and I can't delete it anyway.

Has anyone come across this sort of behaviour with any other files? and if so have they solved the problem.