If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlinks & macros
Is it possible to add a macro to a hyperlink.
I have a formula on a 'menu' page which gives a figure from selected data on a different worksheet. (I have quite a few). I am looking at a way that you can click on that number and it takes you to the worksheet, but then it sorts the data as defined by a filter, i.e. selects all the records with London in them. So whichever number you click on, you only see the data associated to that figure. Any ideas not using VB would be appreciated. Thanks |
#2
|
|||
|
|||
Hyperlinks & macros
It is possible to have a macro executed when you click on a hyperlink. But
that would involve VBA. -- Gary''s Student - gsnu200827 "Mick" wrote: Is it possible to add a macro to a hyperlink. I have a formula on a 'menu' page which gives a figure from selected data on a different worksheet. (I have quite a few). I am looking at a way that you can click on that number and it takes you to the worksheet, but then it sorts the data as defined by a filter, i.e. selects all the records with London in them. So whichever number you click on, you only see the data associated to that figure. Any ideas not using VB would be appreciated. Thanks |
Thread Tools | |
Display Modes | |
|
|