Hyperlink

B

bimseun

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
 
D

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
 
Top