Hyperlink Code will not work in XL2002

[Guest]

Hi All

I have a bit of hyperlink code for which individuals using XL2002 are unable to utilize or view the hyperlinks
I run the code and send out the workbook. But then receive emails from XL2002 users that the links are useless to them

ActiveSheet.Hyperlinks.Add Anchor:=Cells(cRow - 1 + cSht, cCol),
Address:="", SubAddress:="'" & Sheets(cSht).Name & "'!A1

The hyperlinks need to be viewed in XL versions 97-2002. The above code works in 95-2000. Any suggestions

Thank You
RozB

 

[Guest]

is one limited to only a bits of assistance? is there a limit?

 

[Dave Peterson]

The only limits I've seen on responses occur when the post is too vague (not
enough details), contains an attachment, or just too complex--either would take
hours to set up a test scenario or it would turn into a part time job.

Hyperlinks work ok for me in xl2002.