Code works fine in 2003 excel but fails in 2007

Hey everyone,
Pretty self-explanatory: some of our computers use 2003 and some use 2007. The code was made on the 2003 version but when the file is opened by a 2007 version excel it doesn't work as intended.

There are hyperlinks in one file that, when clicked, go to another worksheet in the same file and highlight the appropriate row. Here is the code that is coming up for both but it's not working on 2007 for some reason. I think there must be an easy fix for this right?

Please Login or Register  to view this content.

It hyperlinks to the correct worksheet but then it doesn't highlight the correct row within the worksheet. For example, in 2003 version we click on Company J's hyperlink and it moves to the general company information worksheet and highlights Company J's information and scrolls down to make it visible if needed.
In the 2007 version when we click on Company J's hyperlink it'll move over to the general company information sheet and will choose the right row but won't highlight.