AW: Sortieren zurücksetzen
24.01.2011 18:06:31
Josef
Hallo Heinz,
vielleicht so.
' **********************************************************************
' Modul: Tabelle1 Typ: Element der Mappe(Sheet, Workbook, ...)
' **********************************************************************
Option Explicit
Private Sub Worksheet_Activate()
On Error GoTo ErrExit
Application.ScreenUpdating = False
Unload UserForm8
Me.Unprotect Password:="test"
With Range("C3:C154")
.Formula = "=ROW()"
.Value = .Value
.NumberFormat = ";;;"
End With
With Range("A3:C154")
.Sort Key1:=Range("B3"), _
Order1:=xlDescending, Key2:=Range("A3"), _
Order2:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption2:=xlSortNormal
.Columns.AutoFit
End With
Range("A2").Select
Me.Protect Password:="test"
ErrExit:
Application.ScreenUpdating = True
End Sub
Private Sub Worksheet_Deactivate()
On Error GoTo ErrExit
Application.ScreenUpdating = False
Unload UserForm8
If Range("C3").NumberFormat = ";;;" Then
Me.Unprotect Password:="test"
With Range("A3:C154")
.Sort Key1:=Range("C3"), _
Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption2:=xlSortNormal
.Columns.AutoFit
.Columns(3).ClearContents
.Columns(3).NumberFormat = "General"
End With
Range("A2").Select
Me.Protect Password:="test"
End If
ErrExit:
Application.ScreenUpdating = True
End Sub
Gruß Sepp