Hyperlink

[Guest]

How do i insert hyperlink so that users would not have to "press ctrl click"
but rather just click to get to the desire folder or file?
oro ago

 

[Don Guillett]

right click on sheet tab>view code>left window select worksheet>right window
select double_click

Sample
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
Else
Sheets(ActiveCell.Value).Select
End If
Application.DisplayAlerts = True
End Sub