Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 11,058
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks: Hyperlinks change on copy/paste? Rick S. Excel Worksheet Functions 0 November 13th 07 09:19 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
Changing Hyperlinks in Macros Elise148 Excel Discussion (Misc queries) 5 June 22nd 07 05:08 PM
Opening Word Document with Macros and not hyperlinks. Thew21 Excel Discussion (Misc queries) 2 April 4th 07 07:43 PM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"