Danke im Voraus.....Peter
Private Sub Verbieten()
If Range("A5") = "" Then
Application.CommandBars(1).Controls(1).CommandBar.Controls(16).Enabled = False
Else
Application.CommandBars(1).Controls(1).CommandBar.Controls(16).Enabled = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$5" Then
If Target.Value = "" Then
Application.CommandBars(1).Controls(1).CommandBar.Controls(16).Enabled = False
Else
Application.CommandBars(1).Controls(1).CommandBar.Controls(16).Enabled = True
End If
End If
End Sub
Target.Address