Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink - custom view
Is it possible that when a user clicks on a hyperlink, the custom view
appears? And how would I write that into a macro? Annette |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink - custom view
Annette,
You could link the Hyperlink back to itself and then use the FollowHyperlink event to show the view. Something like the following should work... '-- Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) 'hyperlink cell If Target.Range.Address = "$B$5" Then ThisWorkbook.CustomViews("Current Inventory").Show End If End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Annette" wrote in message Is it possible that when a user clicks on a hyperlink, the custom view appears? And how would I write that into a macro? Annette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View Hyperlink in another cell | Excel Discussion (Misc queries) | |||
Custom View | Excel Worksheet Functions | |||
View Custom View with Sheet Protection | New Users to Excel | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) |