Solved: excel2000 question

[vzachin]

hi,

i have a piece of code that will work on excel2003 but will not work in excel2000 because the feature is not there.
how can i incoporate into the code to check the version of excel running?

[vba]
if excel2003 then
Worksheets("sheet1").tab.ColorIndex = 5
end if
[/vba]
when i write code using excel2003, is there any (aside from running the code in an older version) to know that the code will fail?

thanks
zach

[mdmackillop]

Check out this KB item

[vzachin]

thanks malcolm
just what i needed