Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Changing Hyperlinks in Macros | Excel Discussion (Misc queries) | |||
Opening Word Document with Macros and not hyperlinks. | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |