add menu to file edit menu Free Excel Macros (VBA) | Excel Programs

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php

Private Sub Workbook_Open()
   Dim cmb As CommandBar
   Dim cmbp As CommandBarPopup
   Set cmb = Application.CommandBars. _
                Add(Name:="MeineLeiste", _
                    Position:=msoBarTop, _
                    Temporary:=True)
   Set cmbp = cmb.Controls.Add(Type:=msoControlPopup)
   cmb.Visible = True
   cmbp.Caption = "Mein Submenü"
   With cmbp.Controls.Add(Type:=msoControlButton, _
                          Temporary:=True)
      .Caption = "Meine 1. Prozedur"
      .BeginGroup = True
      .FaceId = 59
      .OnAction = "MeineProzedur1"
   End With

With cmbp.Controls.Add(Type:=msoControlButton, _
                          Temporary:=True)
      .Caption = "Meine 2. Prozedur"
      .FaceId = 49
      .OnAction = "MeineProzedur2"
   End With

Set cmb = Nothing
   Set cmbp = Nothing
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
   Dim cmb As CommandBar
   Set cmb = Application.CommandBars("MeineLeiste")
   cmb.Delete
   Set cmb = Nothing
End Sub
Sub MeineProzedur1()
   MsgBox Application.UserName
End Sub

Sub MeineProzedur2()
   MsgBox Now()
End Sub

No	Macro Name
1	add menu to file edit menu
2	add menu to file edit menu
3	Add menu to file edit bar delete
4	excel operators hk
5	excellent menu insert file menu print print preview sheet / page structure remains
6	Codes that prevent and open the vba window and access codes
7	customization of toolbars remains in the file menu
8	add-remove button
9	Create your own extensions and functions in excel
10	add sheet / pages as menus
11	add excel sheets as menus
12	add toolbars to combo box and select from there
13	excelin all menu pushbutton pictures
14	deleting the menu bar and creating a custom menu
15	cancellation of file layout menus and new menu
16	Create a find menu
17	userformless form menu sheet / page select
18	macros box and macros appear
19	Hide and show the file edit menu
20	hide file view edit menu show

Excel Free Macros (VBA)

Add Menu To File Edit Menu

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords