Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange behaviour | Excel Programming | |||
strange behaviour | Excel Programming | |||
Strange if(***) behaviour? | Excel Discussion (Misc queries) | |||
Strange VBA Behaviour | Excel Programming | |||
strange behaviour | Excel Programming |