Customed Context Menu

[Galven]

Hello,

I'd like to customize the Application.CommandBars("Cell") in the following way:

- Delete all buttons
- Add my own buttons

The problem is after deleting everything, the line "ContextMenu.Controls.Add(Type:=msoControlButton, before:=1)" doesn't work anymore.
Given the fact that there is no button anymore, the macro does not understand the "before:=1".

How can I add a first button after deleting everything ?

Thanks

[mehmetcik]

Try entering the line

Please Login or Register  to view this content.

Add your button

Please Login or Register  to view this content.

try adding your button using 1 or (1) instead of "Before:- 1"

Because you disabled alerts Excel should work.

[buran]

Actually

Please Login or Register  to view this content.

does not disable alerts, excel will simply continue with the next line doing nothing in case of error.

begin should be optional, remove it and try the code