CommandBars Aus/Einblenden
31.10.2005 18:09:15
Dieterlem
"Fehler beim Kompilieren: Methode oder datenobjekt nicht gefunden."
Was mache ich falsch?
Sub Workbook_open()
...
If _
Application.Commandbars("Worksheet Menue Bar").Enabled = True Then
Application.Commandbars("Worksheet Menue Bar").Enabled = False
End If
...
Sub Workbook_BeforeClose(Cancel As Boolean)
...
If _
Application.Commandbars("Worksheet Menue Bar").Enabled = False Then
Application.Commandbars("Worksheet Menue Bar").Enabled = True
End If
...
Gruß dieterlem