I have written a moderately complex project in Excel 2000 VBA and it works a treat. Nifty and reliable. Running it in Excel 2007 is however a nightmare. Besides 2007 mangling up all my cell color settings and crashing on line codes it ought not to (all of which I've fixed or can fix), my major problem is that 2007 runs frustratingly slow - it's taking a few seconds up to minutes to run. I do not have such issue when the project is run in Excel 2000.

Is this to be expected (I hope not) or can anyone help to point me in the right diirection? Converting the .xls file to .xlsx or .xlsm doesn't make any difference.

When I step through any procedure one at a time all the codes run perfectly well in 2007 just as it does in 2000. However anytime I press F5 to run through a procedure, Excel 2007 suddenly decides to take an eternity running it.

It's doing my head in. Some please help!