add buttons to an existing menu bar Free Excel Macros (VBA) | Excel Programs

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

Add Buttons To An Existing Menu Bar

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Private Sub Workbook_Open()
   Dim cmb As CommandBar
   Set cmb = Application.CommandBars("Standard")
   With cmb.Controls.Add(Type:=msoControlButton, _
                         Temporary:=True)
      .Caption = "Meine 1. Prozedur"
      .BeginGroup = True
      .FaceId = 59
      .OnAction = "MeineProzedur1"
   End With

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

Set cmb = Nothing
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
   Dim cmb As CommandBar
   Set cmb = Application.CommandBars("Standard")
   With cmb
      .Controls("Meine 1. Prozedur").Delete
      .Controls("Meine 2. Prozedur").Delete
   End With
   Set cmb = Nothing
End Sub
Sub MeineProzedur1()
   MsgBox Application.UserName
End Sub

Sub MeineProzedur2()
   MsgBox Now()
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	add buttons to an existing menu bar
2	Add menu to file edit bar delete
3	Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
4	excel operators hk
5	See buttons and numbers
6	add icons menus and buttons to the sheet / page
7	add a toolbar
8	toolbar creation
9	printing and prompting
10	specifies in detail how many references the book contains (on new sheet / page)
11	list formulas on new sheet / page
12	specifies in detail how many formulas are in the book (on new sheet / page)
13	perfectly deletes the menu to the right mouse and adds print print preview sheet / page structure
14	add toolbars to combo box and select from there
15	excellent menu insert file menu print print preview sheet / page structure remains
16	add time as menu (most reliable)
17	add time as menu
18	Add to right mouse menu
19	deleting the menu bar and creating a custom menu
20	add menu to file edit menu

Excel Free Macros (VBA)

Add Buttons To An Existing Menu Bar

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords