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 |
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 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com