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 and filters
Is there any way that I can set-up a hyperlink to a different worksheet in
the existing file and get a filter to run on that sheet automatically? Thanks, Bob. |
#2
|
|||
|
|||
Hyperlinks and filters
Bob P wrote:
Is there any way that I can set-up a hyperlink to a different worksheet in the existing file and get a filter to run on that sheet automatically? With the filter depending on the hyperlink? Possibly using the Worksheet_FollowHyperlink event if you are using Excel 2000 or later. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Dim stChoice As String ' assume the hyperlink displays the item on which the destination is to be filtered stChoice = Target.Parent.Value Application.EnableEvents = False ' stop recursive call Target.Follow Application.EnableEvents = True ' assume column 1 to be filtered ActiveCell.AutoFilter 1, stChoice End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|