ich habe ein kleines Problem.
Ich lasse per Makro je nach User bestimmte Sachen ausblenden.
Nun bleibt aber die blaue Leiste oben weg, obwohl ich sie eigentlich wieder einblenden lasse.
Hat denn jemand eine Lösung?
Private Sub Workbook_Deactivate()
Dim x As Long
For x = 1 To 26
If Leiste(x) <> "" Then Toolbars(Leiste(x)).Visible = True
Next x
Application.DisplayFormulaBar = True
Application.CommandBars("Worksheet Menu Bar").Controls("Datei").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Fenster").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Format").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Ansicht").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Daten").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Extras").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Bearbeiten").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("Einfügen").Visible = True
Application.CommandBars("Worksheet Menu Bar").Controls("?").Visible = True
End Sub
Private Sub Workbook_Deactivate()
For Each c In Application.CommandBars
c.Enabled = True
Next
End Sub