[已解决]红色外边框

心灵有约

红色外边框.rar (5.99 KB, 下载次数: 12)

2017-2-3 10:04 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

望帝春心

2017-2-3 11:11

1. Sub 宏1()
   
2.     With Selection.Borders(xlEdgeLeft)
   
3.         .LineStyle = xlContinuous
   
4.         .Color = vbRed
   
5.         .TintAndShade = 0
   
6.         .Weight = xlThin
   
7.     End With
   
8.     With Selection.Borders(xlEdgeTop)
   
9.         .LineStyle = xlContinuous
   
10.         .Color = vbRed
    
11.         .TintAndShade = 0
    
12.         .Weight = xlThin
    
13.     End With
    
14.     With Selection.Borders(xlEdgeBottom)
    
15.         .LineStyle = xlContinuous
    
16.         .Color = vbRed
    
17.         .TintAndShade = 0
    
18.         .Weight = xlThin
    
19.     End With
    
20.     With Selection.Borders(xlEdgeRight)
    
21.         .LineStyle = xlContinuous
    
22.         .Color = vbRed
    
23.         .TintAndShade = 0
    
24.         .Weight = xlThin
    
25.     End With
    
26.     Selection.Borders(xlInsideVertical).LineStyle = xlNone
    
27.     Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    
28. End Sub

复制代码

录制的宏

跳转到最佳答案楼层

望帝春心

1. Sub 宏1()
   
2.     With Selection.Borders(xlEdgeLeft)
   
3.         .LineStyle = xlContinuous
   
4.         .Color = vbRed
   
5.         .TintAndShade = 0
   
6.         .Weight = xlThin
   
7.     End With
   
8.     With Selection.Borders(xlEdgeTop)
   
9.         .LineStyle = xlContinuous
   
10.         .Color = vbRed
    
11.         .TintAndShade = 0
    
12.         .Weight = xlThin
    
13.     End With
    
14.     With Selection.Borders(xlEdgeBottom)
    
15.         .LineStyle = xlContinuous
    
16.         .Color = vbRed
    
17.         .TintAndShade = 0
    
18.         .Weight = xlThin
    
19.     End With
    
20.     With Selection.Borders(xlEdgeRight)
    
21.         .LineStyle = xlContinuous
    
22.         .Color = vbRed
    
23.         .TintAndShade = 0
    
24.         .Weight = xlThin
    
25.     End With
    
26.     Selection.Borders(xlInsideVertical).LineStyle = xlNone
    
27.     Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    
28. End Sub

复制代码

录制的宏

yayahzmeng

1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   
2.     On Error Resume Next
   
3.     Application.ScreenUpdating = False
   
4.     If Target.Count = 1 Then Exit Sub
   
5.     With Selection.Borders
   
6.         .Color = vbRed
   
7.         .Weight = xlThick
   
8.     End With
   
9.     Selection.Borders(xlInsideVertical).LineStyle = xlNone
   
10.     Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    
11.     Application.ScreenUpdating = True
    
12. End Sub

复制代码

帖子荒啊，连版主都来凑这个小热闹 ：）