Private Sub workbook_Open()
symbolleiste_erstellen true
End Sub
aufrufen möchte, sagt mir excel:" fehler beim kompilieren: argument ist nicht optional"
woran liegt das? und was muss ich machen, um sie fehlerfrei zu starten?
Sub symbolleiste_erstellen(strName As String, intID As Integer)
Dim mnuCommandbar As CommandBar
Dim mnuMenuControl As CommandBarControl
Dim mnuControlButton As CommandBarControl
Dim intPosition As Integer
intPosition = CommandBars(95).Controls.Count
Set mnuCo mmandbar = _
CommandBars.Add(strName, msoBarFloating, , True)
Set mnuMenuControl = _
CommandBars(95).Controls _
.Add(msoControlPopup, intID, , intPosition, True)
mnuMenueControl.Caption = strName
Set mnuControlButton = _
mnuCommandbar.Controls.Add(Type:=msoControlButton)
With mnuControlButton
.Style = msoButtonCaption
.Caption = "Datenermittlung und -aufbereitung"
.TooltipText = "Datenermittlung und -aufbereitung"
End With
Set mnuControlButton = _
mnuCommandbar.Controls.Add(Type:=msoControlButton)
With mnuControlButton
.Style = msoButtonCaption
.Caption = "Ist-Analyse"
.TooltipText = "Ist-Analyse"
End With
Set mnuControlButton = _
mnuCommandbar.Controls.Add(Type:=msoControlButton)
With mnuControlButton
.Style = msoButtonCaption
.Caption = "Bedarfsberechnung Ressourcen"
.TooltipText = "Bedarfsberechnung Ressourcen"
End With
mnuCommandbar.Visible = True
Set mnuControlButton = Nothing
Set mnuMenuControl = Nothing
End Sub