Eine bescheidene Frage hab ich: Läßt sich die Markierung der akt. Zelle anders gestalten. Die Akt. Zelle oder ein Bereich wird immer mit dicken Strichen umrahmt. Gibt es da etwas in den Optionen um das zu ändern?
Danke für die Hilfe
Karl-Heinz
' Unter DieseArbeitsmappe
Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Selection.Interior.Color = 65535
End Sub
' Unter der Tabelle
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Selection.Interior.Color = 65535
End Sub
Gruß Hajo
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Sh.Cells.Interior.ColorIndex = xlNone
Target.Interior.Color = 65535
End Sub
Gruß von Luschi
Mit dieser Auszeichnung bringt Microsoft seinen Respekt zum Ausdruck vor dem Engagement aller _
MVP's,
die jeden Tag den Gemeinschaftssinn, das Leben anderer Menschen und den technologischen
Fortschritt fördern.
Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
With Cells
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
.Borders(xlEdgeLeft).LineStyle = xlNone
.Borders(xlEdgeTop).LineStyle = xlNone
.Borders(xlEdgeBottom).LineStyle = xlNone
.Borders(xlEdgeRight).LineStyle = xlNone
.Borders(xlInsideVertical).LineStyle = xlNone
.Borders(xlInsideHorizontal).LineStyle = xlNone
End With
With Target
With .Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Color = -11489280
.Weight = xlThick
End With
With .Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Color = -11489280
.Weight = xlThick
End With
With .Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Color = -11489280
.Weight = xlThick
End With
With .Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Color = -11489280
.Weight = xlThick
End With
End With
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Cells.Borders.LineStyle = xlNone
Target.BorderAround 1, 4, -11489280
End Sub