Private Sub [COLOR=#ff0000]Worksheet_SelectionChange[/COLOR](ByVal Target As Range)
On Error GoTo Thoat 'khi chon nguyen cot
If Target.Column = 2 Then
If Target.Value = "-" Then
Range("C1").ClearContents
If Right(Selection.End(xlDown).Address, 5) <> 65536 Then
Range("C1") = Range(Selection, Selection.End(xlDown)).SpecialCells(xlCellTypeBlanks).Address
Hyperlinks.Add Anchor:=ActiveCell.Offset(, 1), Address:="", ScreenTip:=Range("C1").Value
Else
Range("C1") = ActiveCell.Offset(1, 0).Address & ":" & Range("C65536").End(xlUp).Offset(0, -1).Address
Hyperlinks.Add Anchor:=ActiveCell.Offset(, 1), Address:="", ScreenTip:=Range("C1").Value
End If
End If
End If
Thoat:
Exit Sub
End Sub
Private Sub [COLOR=#ff0000]Worksheet_BeforeDoubleClick[/COLOR](ByVal Target As Range, Cancel As Boolean)
If Target.Column = 2 Then
Cancel = True
If Target.Value <> "" Then
If Target.Row = 1 Then
If Target.Value = "+" Then
Call showall_row
Else
Call hideall_row
End If
Else
ScreenTip = GetHyperlinkScreenTip(ActiveCell.Offset(, 1))
If Target.Value = "-" Then
Range(ScreenTip).EntireRow.Hidden = True 'hide
ActiveCell.Value = "+"
Else
Range(ScreenTip).EntireRow.Hidden = False 'show
ActiveCell.Value = "-"
End If
End If
End If
End If
End Sub