| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
More than one Hyperlink for a single cell
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
No, why do you want to do this?
-- If this helps, please click "Yes" <<<<<<<<<<< "Rechie" wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve. Pete On Oct 26, 8:00*am, Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Hi ,
Example is in A1 =Main Project Name Under this Main Project name , there are 3 more sub projects that I want to link the details. Work sheet is only visible with MainProject . "Pete_UK" wrote: Well, you could have a hyperlink formula controlled by some IF function. Give us some more details of what you want to achieve. Pete On Oct 26, 8:00 am, Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
I'm sorry, but that doesn't make any sense to me.
Please try to describe what you have and what you want to do with it. Pete On Oct 26, 11:20*am, Rechie wrote: Hi , Example is in A1 =Main Project Name Under this Main Project name , there are 3 more sub projects that I want to link the details. Work sheet is only visible with MainProject . "Pete_UK" wrote: Well, you could have a hyperlink formula controlled by some IF function. Give us some more details of what you want to achieve. Pete On Oct 26, 8:00 am, Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. .- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
In a simple way, If possible I need to have 3 links in a single cell (Project
Name), because this particular Project has 3 documents lying in other places. In a normal sitiuation I have to type the same Project name in 3 different cell range (A1,A2 and A3) and link it individually to 3 different Docs. e.g. A1= "Project A" link to Doc1 A2 = "Project A" link to Doc2 A3 = "Project A" link to Doc3 "Pete_UK" wrote: I'm sorry, but that doesn't make any sense to me. Please try to describe what you have and what you want to do with it. Pete On Oct 26, 11:20 am, Rechie wrote: Hi , Example is in A1 =Main Project Name Under this Main Project name , there are 3 more sub projects that I want to link the details. Work sheet is only visible with MainProject . "Pete_UK" wrote: Well, you could have a hyperlink formula controlled by some IF function. Give us some more details of what you want to achieve. Pete On Oct 26, 8:00 am, Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. .- Hide quoted text - - Show quoted text - . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Try this.
Open only Doc1, Doc2, Doc3 Save As a workspace(*.resume.xlw) file then close. Now hyperlink to that file through InsertHyperlinkExisting file or webpage. All three Docs will open from that one hyperlink. Gord Dibben MS Excel MVP On Mon, 26 Oct 2009 07:59:01 -0700, Rechie wrote: In a simple way, If possible I need to have 3 links in a single cell (Project Name), because this particular Project has 3 documents lying in other places. In a normal sitiuation I have to type the same Project name in 3 different cell range (A1,A2 and A3) and link it individually to 3 different Docs. e.g. A1= "Project A" link to Doc1 A2 = "Project A" link to Doc2 A3 = "Project A" link to Doc3 "Pete_UK" wrote: I'm sorry, but that doesn't make any sense to me. Please try to describe what you have and what you want to do with it. Pete On Oct 26, 11:20 am, Rechie wrote: Hi , Example is in A1 =Main Project Name Under this Main Project name , there are 3 more sub projects that I want to link the details. Work sheet is only visible with MainProject . "Pete_UK" wrote: Well, you could have a hyperlink formula controlled by some IF function. Give us some more details of what you want to achieve. Pete On Oct 26, 8:00 am, Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. .- Hide quoted text - - Show quoted text - . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
I tried to insert text box but the hyperlink function is dimmed (not active).
"Jon Peltier" wrote: You could use three textboxes that fit over the cell. Each one should be linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Did you use the textbox from the Drawing toolbar?
Try right clicking on it once more by the edge. But I'd use a rectangle from the drawing toolbar instead. Rechie wrote: I tried to insert text box but the hyperlink function is dimmed (not active). "Jon Peltier" wrote: You could use three textboxes that fit over the cell. Each one should be linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Shapes do not have hyperlinks. But you can format the text to look like
hyperlinks, and assign a macro to each textbox/rectangle. The macro needs this line of code: ActiveWorkbook.FollowHyperlink sAddress where sAddress is the address of the hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: I tried to insert text box but the hyperlink function is dimmed (not active). "Jon Peltier" wrote: You could use three textboxes that fit over the cell. Each one should be linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Yes, assigning a macro would work, but so should assigning a hyperlink.
Jon Peltier wrote: Shapes do not have hyperlinks. But you can format the text to look like hyperlinks, and assign a macro to each textbox/rectangle. The macro needs this line of code: ActiveWorkbook.FollowHyperlink sAddress where sAddress is the address of the hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: I tried to insert text box but the hyperlink function is dimmed (not active). "Jon Peltier" wrote: You could use three textboxes that fit over the cell. Each one should be linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than one Hyperlink for a single cell
Ah, I didn't realize a hyperlink can be assigned to a shape.
- Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Dave Peterson wrote: Yes, assigning a macro would work, but so should assigning a hyperlink. Jon Peltier wrote: Shapes do not have hyperlinks. But you can format the text to look like hyperlinks, and assign a macro to each textbox/rectangle. The macro needs this line of code: ActiveWorkbook.FollowHyperlink sAddress where sAddress is the address of the hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: I tried to insert text box but the hyperlink function is dimmed (not active). "Jon Peltier" wrote: You could use three textboxes that fit over the cell. Each one should be linked to a macro that follows a particular hyperlink. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Rechie wrote: Hi Experts, Is it possible to have 3 hyperlinks in a single cell? Thanks for your help. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove so many hyperlink in a single click? | Excel Discussion (Misc queries) | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Creating a Hyperlink from a Single Word | Links and Linking in Excel | |||
| is there a way to add single digits within a single cell? | Excel Worksheet Functions | |||
Hybrid Mode
