Excel document works in Excel 2003 but goes haywire in Excel 2002 - HELP!

**Glensafro** · 03-07-2012, 08:10 AM

Hi guys

I have created a workbook in Excel 2010 under the impression that the earliest version of Excel we have in the office is 2003 so I have been making sure the book works in 2003 as it should - and it does - but I have just rolled the sheet out to a couple of guys to test and they appear to have 2002. This seems to play havoc with the functionality of the spreadsheet, when an option is selected from a drop down list the workbook jumps sheets to a completely different sheet and all of the toolbars and the taskbars at the top of excel seem to stop working. I don't think it is an unsupported function in any of the cells because before when I have had compatability issues the built-in compatability checker has flagged up an error, so I think the problem may lie somewhere in the VBA code in the sheet. The workbook only seems to go wrong when I do something that triggers the worksheet change code on sheet1 - Form (a rather large and convoluted code - I am relatively new to VBA). If this is the case does anyone have any ideas how I can find out what part of the code is incompatable with Excell 2002?

Thanks,

Glen

**TMS** · 03-07-2012, 08:34 AM

I don't have Excel 2002 to test this. One thought though is to remove the UDF for IFERROR. Excel 2007 complains about it because there is a built in function. Maybe Excel 2002 doesn't like it either.

Regards, TMS

**Glensafro** · 03-07-2012, 01:06 PM

Hey,

I tried removing the formula and replacing all of my IFERROR functions with an amalgamation of the IF and ISERROR functions which work in 2002 and this has done the trick, so now rather than using IFERROR(my_formula,valueiferror) I am using IF(ISERROR(my_formula),valueiferror,my_formula), therefore removing the need for my UDF.

Thanks very much for the help,

Glen

**mahju** · 03-07-2012, 01:06 PM

Hi

Yes problem with the VB code.
Some command in vb code may include sort, advance filter have different perameter name than in 2003. I had also make some code in 2003 but it does not work in 2002.

Read help on sort in 2002 and 2003 to see the difference

Regards