Follow Hyperlink strange behaviour

R

Rainer Bielefeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

html hyperlinks using sub address 0
VBA - Hyperlink Function Combined with Find 6
How to extract "destination address" from Hyperlink - VBA 9
VBA Configure Proxy Server Settings of IE 0
Adding custom menus to existing excel application 0
wrong Hyperlink-Values 1
Hyperlink fails to open on the first click 0
hyperlinking to charts in file 1

Top