|
右键点击工作表标签,将下面的代码粘贴到VBE窗口光标处,然后返回工作表。
- Dim hbk As Boolean
- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- Dim Rng As Range
- Cancel = True
- If Target.Row = 1 Or Target.Column = 1 Then Exit Sub
- If Not hbk Then
- hbk = True
- UsedRange.Borders.LineStyle = 0
- End If
- If Target.Value = "" Then
- Set Rng = Target.End(2)
- If Rng.Value = "" Then
- hbk = False
- Set Rng = Target.Offset(0, 1)
- Else
- Worksheet_BeforeDoubleClick Rng, True
- End If
- With Range(Target.Offset(-1), Rng.Offset(-1, -1)).Borders(9)
- .LineStyle = 1
- .Color = 255
- .Weight = 3
- End With
- Else
- With Target.Borders(7)
- .LineStyle = 1
- .Color = 255
- .Weight = 3
- End With
- Worksheet_BeforeDoubleClick Target.Offset(1), True
- End If
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|