Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$5" Then
Sheets(1).Activate
' Waren Ausgang Makro
Columns("A:A").Select
Selection.EntireColumn.Hidden = True
Columns("b:l").Select
Selection.EntireColumn.Hidden = False
Columns("G:G").Select
Selection.EntireColumn.Hidden = True
Columns("I:I").Select
Selection.EntireColumn.Hidden = True
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$6" Then
Sheets(1).Activate
' Wareneingang Makro
Columns("A:A").Select
Selection.EntireColumn.Hidden = True
Columns("B:l").Select
Selection.EntireColumn.Hidden = False
Columns("f:f").Select
Selection.EntireColumn.Hidden = True
Columns("h:h").Select
Selection.EntireColumn.Hidden = True
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select
End If
End Sub
Ich Habe Excel 2021Danke