Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
When is =HYPERLINK() not a hyperlink?
In Excel 2002, if I insert a hyperlink to, say, My.jpg using Insert /
Hyperlink, I can launch the file in at least 3 ways: 1) Hovering over the link displays a tooltip, confirming Excel knows a hyperlink is there; and clicking it launches My.jpg. 2) The context menu displaying on Right-Click (or Shift-F10) contains "Open hyperlink" and "Edit Hyperlink", which work fine. 3) In a macro, Selection.Hyperlinks(1).Follow works fine. But if I manually put =HYPERLINK("My.jpg") into a cell, then although 1) The tooltip displays and mouse click launches the file, 2) the context menu LACKS "Open" and "Edit hyperlink", and 3) Hyperlinks.Follow chokes. As Davy Jones muttered sotto voce in the intro to the album-only version of "Daydream Believer", "It's because I'm short, I know." I'm a keyboard maven and only like to touch the highly unsanitary mouse about once every 10 mins. I wanna use Shift-F10. Besides, what sense can it possibly make for Excel to tell you a hyperlink is there, only to tell you it isn't? Sounds like an interface bug to me. I'm using =HYPERLINK() because I iterate the link in several places, and I want them all to update if I rename the file. I do that indirectly: E.g., A1 contains "My.jpg". A2 contains =HYPERLINK($A$1). I then copy A2's formula to several locations. If I change the filename in A1, all links update. So how do I get Excel 2002's context menu and VBA statement to work correctly--while retaining the indirectness I need for auto update? If this can't be done, I'll still appreciate knowing why =HYPERLINK() and Insert / Hyperlink differ. Thanks much. *** |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
When is =HYPERLINK() not a hyperlink?
The reason that there is little tooling for =HYPERLINK() as compared to
"real" hyperlinks, is that function-style hyperlinks are not part of the object model. When you select Edit Hyprelinks... you are bring up a GUI that allows you to set the object's properties or use the object's methods. Because there is no object, the GUI has nothing to operate upon. For example, if you have a cell with =HYPERLINK("http://www.cnn.com") in an otherwise empty worksheet: MsgBox (ActiveSheet.Hyperlinks.Count) will report 0 It is hard to even locate function-style hyperlinks on a worksheet, let alone pry out their destinations so you can Follow them. -- Gary''s Student - gsnu2007 " wrote: In Excel 2002, if I insert a hyperlink to, say, My.jpg using Insert / Hyperlink, I can launch the file in at least 3 ways: 1) Hovering over the link displays a tooltip, confirming Excel knows a hyperlink is there; and clicking it launches My.jpg. 2) The context menu displaying on Right-Click (or Shift-F10) contains "Open hyperlink" and "Edit Hyperlink", which work fine. 3) In a macro, Selection.Hyperlinks(1).Follow works fine. But if I manually put =HYPERLINK("My.jpg") into a cell, then although 1) The tooltip displays and mouse click launches the file, 2) the context menu LACKS "Open" and "Edit hyperlink", and 3) Hyperlinks.Follow chokes. As Davy Jones muttered sotto voce in the intro to the album-only version of "Daydream Believer", "It's because I'm short, I know." I'm a keyboard maven and only like to touch the highly unsanitary mouse about once every 10 mins. I wanna use Shift-F10. Besides, what sense can it possibly make for Excel to tell you a hyperlink is there, only to tell you it isn't? Sounds like an interface bug to me. I'm using =HYPERLINK() because I iterate the link in several places, and I want them all to update if I rename the file. I do that indirectly: E.g., A1 contains "My.jpg". A2 contains =HYPERLINK($A$1). I then copy A2's formula to several locations. If I change the filename in A1, all links update. So how do I get Excel 2002's context menu and VBA statement to work correctly--while retaining the indirectness I need for auto update? If this can't be done, I'll still appreciate knowing why =HYPERLINK() and Insert / Hyperlink differ. Thanks much. *** |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
When is =HYPERLINK() not a hyperlink?
Student:
Thanks very much for your reply. Helps me understand things. *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |