Forum Discussion
Solved
Excel VBA and starting URL by clicking Shapes ???
I have a WorkSheet with a lot of Shapes. Each Shape can be "Loaded" with ScreenTip and a Link by a form accesable by the user by clicking the Shape. My users can enter ScreenTip and URL and edit th...
- I think I found the cause for starting in SafeMode - if you start FireFox (or any other browser, I think) while pressing the SHIFT-key the browser is FORCED to start in SafeMode ... that's my problem !
I have to choose another key to press when I want the users to open the link !
???? I don't get you ... I see NO FollowHyperlink in Application !
But I must admit you CAN type it AND compile it without errors, but it wont run - it reports:
Run-time error 438
Object doesn't support this property or method
It seems like I have to use this - it works like I want to:
ActiveWorkbook.FollowHyperlink Sh.Hyperlink.Address & "#" & Sh.Hyperlink.SubAddress
UPDATE:
No, this last code change didn't do it either - I still get this message with SafeMode or RESET when the browser is NOT running !
I think I found the cause for starting in SafeMode - if you start FireFox (or any other browser, I think) while pressing the SHIFT-key the browser is FORCED to start in SafeMode ... that's my problem !
I have to choose another key to press when I want the users to open the link !
I have to choose another key to press when I want the users to open the link !