der Buchsatbe in A1 und A2 soll immer "gross" sein.
macht excel sowas?
danke dafür.
GZ
| ||||||||
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A2")) Is Nothing Then
Application.EnableEvents = False
Target = Application.Proper(Target)
Application.EnableEvents = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B6,C6,B8,B10,C10")) Is Nothing Then
Application.EnableEvents = False
Target = Application.Proper(Target)
Application.EnableEvents = True
End If
End Sub
Private Sub Workbook_Open()
End Sub
Sub einschalten()
Application.EnableEvents = True
End Sub