Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
as starting point some code: Sub Add_Item() Dim New_Entry As Object Set New_Entry = CommandBars("Cell").Controls.Add(Temporary:=True) On Error Resume Next New_Entry.Controls("My message").Delete On Error Goto 0 With New_Entry .Caption = "My message" .OnAction = "Message" End With End Sub Sub Message() MsgBox "Now you code yould start" End Sub Sub Delete_Item() Dim myControl As CommandBarButton For Each myControl In CommandBars("Cell").Controls If myControl.Caption = "My message" Then myControl.Delete End If Next End Sub -- Regards Frank Kabel Frankfurt, Germany "PT SPORT CONTRUCTION CO.,LTD" schrieb im Newsbeitrag ... how to make it ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
right click menu excel | New Users to Excel | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
right click menu reset? | Excel Programming | |||
Right click menu in my form | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming |