Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Hi everybody,
I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Daniel,
Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Hello Bob,
Many thanks for your message. Actually, right-clicking on the shape doesn't give me the hyperlink option. Do u think it's because I have the 2002 version of Excel ? Tks again, Best rgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Hi Daniel,
I only have XL2000 here, and I get it. Just checked on my desktop which does have XL2002, and hyperlink is there. Where did the shape come from? I was referring to items from the Drawing toolbar. Bob "Daniel" wrote in message ... Hello Bob, Many thanks for your message. Actually, right-clicking on the shape doesn't give me the hyperlink option. Do u think it's because I have the 2002 version of Excel ? Tks again, Best rgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Hello Bob,
Thank you for your message. Actually the graphic was created thru Menu |Insert Graphic, not from the drawing feature. This explains. Each part of the "doughnut" graphic corresponds to a cell in the Table, and you can actually select each individual "cell" in the graphic and modify the content of the corresponding cell in the table. So I thought the hyperlinks in the table could also be made available in the graphic. It may need some VBA programming. Tks again, with brgds, Daniel "Bob Phillips" a écrit dans le message de ... Hi Daniel, I only have XL2000 here, and I get it. Just checked on my desktop which does have XL2002, and hyperlink is there. Where did the shape come from? I was referring to items from the Drawing toolbar. Bob "Daniel" wrote in message ... Hello Bob, Many thanks for your message. Actually, right-clicking on the shape doesn't give me the hyperlink option. Do u think it's because I have the 2002 version of Excel ? Tks again, Best rgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Daniel,
I don't have that option. When you right-click the shape, does it have an Assign Macro option? If so, I can give you a macro to do it. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hello Bob, Thank you for your message. Actually the graphic was created thru Menu |Insert Graphic, not from the drawing feature. This explains. Each part of the "doughnut" graphic corresponds to a cell in the Table, and you can actually select each individual "cell" in the graphic and modify the content of the corresponding cell in the table. So I thought the hyperlinks in the table could also be made available in the graphic. It may need some VBA programming. Tks again, with brgds, Daniel "Bob Phillips" a écrit dans le message de ... Hi Daniel, I only have XL2000 here, and I get it. Just checked on my desktop which does have XL2002, and hyperlink is there. Where did the shape come from? I was referring to items from the Drawing toolbar. Bob "Daniel" wrote in message ... Hello Bob, Many thanks for your message. Actually, right-clicking on the shape doesn't give me the hyperlink option. Do u think it's because I have the 2002 version of Excel ? Tks again, Best rgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 : question on Hyperlinks
Hello Bob,
Thank you so much for your message, and sorry for late reply. Was away for a couple of days. I do not have the "Assign macro" option. You wrote you got a micro to do it ? Brgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, I don't have that option. When you right-click the shape, does it have an Assign Macro option? If so, I can give you a macro to do it. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hello Bob, Thank you for your message. Actually the graphic was created thru Menu |Insert Graphic, not from the drawing feature. This explains. Each part of the "doughnut" graphic corresponds to a cell in the Table, and you can actually select each individual "cell" in the graphic and modify the content of the corresponding cell in the table. So I thought the hyperlinks in the table could also be made available in the graphic. It may need some VBA programming. Tks again, with brgds, Daniel "Bob Phillips" a écrit dans le message de ... Hi Daniel, I only have XL2000 here, and I get it. Just checked on my desktop which does have XL2002, and hyperlink is there. Where did the shape come from? I was referring to items from the Drawing toolbar. Bob "Daniel" wrote in message ... Hello Bob, Many thanks for your message. Actually, right-clicking on the shape doesn't give me the hyperlink option. Do u think it's because I have the 2002 version of Excel ? Tks again, Best rgds, Daniel "Bob Phillips" a écrit dans le message de ... Daniel, Forget the cell hyperlink, if you right-click the shape, that should give you the option of a hyperlink. -- HTH RP (remove nothere from the email address if mailing direct) "Daniel" wrote in message ... Hi everybody, I created a simple table, containing numbers, and associated a "doughnut" type graphic. I also created a hyperlink in some of the cells of the table. My question is : how can I make these hyperlinks active in the graphic ? In other words, I would like to be able to click on a given zone of the graphic instead of clicking in the corresponding cell in the table in order to "hyperlink". Thanks in advance for your kind help. With best regards, Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to permanently turn off hyperlinks in Excel 2002 | Excel Discussion (Misc queries) | |||
Activate Hyperlinks - Excel 2002 | Excel Discussion (Misc queries) | |||
hyperlinks not working in excel 2002 SP3 | Excel Discussion (Misc queries) | |||
Excel 2002 : question on hyperlinks | New Users to Excel | |||
Excel 2002 Hyperlinks and redundant rows | Excel Programming |