Wer kann mir da helfen?
Mit bestem Dank!
Guido Bünzli
Private Sub Worksheet_Change(ByVal Target As Range)
ScrollArea = ActiveCell.Offset(1, 0).Address
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
ScrollArea = Rows(ActiveCell.Offset(1, 0).Row).Address
End Sub
Private Sub Worksheet_Activate()
Me.Protect password:="PW", userinterfaceonly:=True
Me.EnableSelection = xlUnlockedCells
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo ERRORHANDLER
Rows(Target.Row).Locked = True
Cells(Target.Row + 1, Target.Column).Locked = False
ERRORHANDLER:
Application.EnableEvents = True
End Sub
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 13 Then CommandButton2 = True
End Sub