Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A2" Then 'Auwahlfeld
Application.EnableEvents = False
Columns.Hidden = False
For col = 5 To 16
If Cells(2, col) <> Target.Value Then Columns(col).Hidden = True 'ggf. Zeile anpassen
Next col
Application.EnableEvents = True
End If
End Sub