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
