View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
It Is Me Here It Is Me Here is offline
external usenet poster
 
Posts: 7
Default Two hyperlinks in 1 piece of text?

How do I actually create the Macro though? I can't use VB, so I don't know
what to do!

"Jim Rech" wrote:

Is it possible to create two hyperlinks in one piece of text?


A hyperlink is a property of a cell not the text in it, so no.

But you could put a text box on a worksheet, make it look like a hyperlink,
and assign a macro to it. That macro could determine if Ctrl, etc. were
down when the click occurred.

--
Jim
"It Is Me Here" wrote in message
...
Is it possible to create two hyperlinks in one piece of text? E.g.
Ctrl+Clicking would open one hyperlink, and Alt+Clicking or
Shift+Ctrl+Clicking would open another?