Follow Hyperlink strange behaviour
 

Hi,

I've a Workbook which has in some Cells Hyperlinks to Cells in another Workbook.
If I click on such a link, Excel opens the other Workbook, activates the Sheet and selects the Cell - everything fine.
But if I follow the Hyperlink in VBA, Excel only opens the Workbook but does not activate the Sheet and Cell - it
doesn't matter if the Workbook is already open or not?

In VBA the Address of the Hyperlink is Workbook.xls and the SubAddress is 'SheetName'!A2 .
For me it looks like Excel follows only the Address but not the SubAddress.

Any ideas?

Regards,

billy