Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiperlinks to sheet (dinamic or based on a cell valeu)
Hi guys.
I have a "central" sheet that contains hiperlinks to all other sheets in the worrk book. The other sheet names mau vary from day to day, so i have to make my hiperlinks "dinamic" or based in value of the next cell. Is this possible??? thanks a lot (once again!!!!) SpeeD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiperlinks to sheet (dinamic or based on a cell valeu)
SpeeD
You can use the Worksheet_FollowHyperlink event. Set up all the hyperlinks so that the underlying address points to the same cell that holds the hyperlink. Basically that will cause the hyperlink to do nothing at all. Then use the event to control what happens when the hyperlink is clicked. It might look like this If Target.Range.Column = 1 Then Me.Parent.Sheets(Target.Range.Offset(0,1).Value).A ctivate End If This says that if the hyperlink is in column A, then activate the sheet whose name is in column B. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "SpeeD" wrote in message ... Hi guys. I have a "central" sheet that contains hiperlinks to all other sheets in the worrk book. The other sheet names mau vary from day to day, so i have to make my hiperlinks "dinamic" or based in value of the next cell. Is this possible??? thanks a lot (once again!!!!) SpeeD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Dinamic sheet in web format | Charts and Charting in Excel | |||
How can I extract automat. the email from a list of hiperlinks? | Excel Discussion (Misc queries) | |||
Linking a dinamic cell value from one sheet to another | Excel Discussion (Misc queries) | |||
How to dinamic cell that searches for "value1 & value2" in table. | Excel Discussion (Misc queries) |