Don't make double items in context menu

[ESF]

Hello,

Under the right-click menu I added an item on a specific range in Excel. The location in Excel knows what to add into the menu (a for creating a heading or a new line item). When I right-click somewhere else the custom menu is removed. So far so good.

When a right-click follows a right-click multiple times the menu item is added again and again. The routine should check weather the items exists and if now, create.

This is what I made (with some help of 'Google')

Right-click code:

Please Login or Register  to view this content.

Create and remove code:

Please Login or Register  to view this content.

Does anybody know what I did wrong or how I can improve this?

Thank you in advance!
Erik

[Bob Phillips]

You haven't provided all of those procedures referred to in the right-click event.

[ESF]

You haven't provided all of those procedures referred to in the right-click event.

The code for creating headings is nearly the same as for creating new line items. That's why I didn't insert this:

Please Login or Register  to view this content.

[snb]

Zo kan het ook...
Instead of adding/deleting buttons, I'd prefer to make them visible/invisible.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[romperstomper]

Personally I find it easier to create a new commandbar and show that instead of modifying the built-in one.

[ESF]

Thank you for your (fast!) advices. I'll try this myself...
Actually I was already very pleased with this initial result as I am a real beginner in VBA.

[ESF]

Instead of adding/deleting buttons, I'd prefer to make them visible/invisible.

Please Login or Register  to view this content.

I just tried your suggestion and copied your code but receive this error: 'Compile Error: Variable Not Defined' at the position 'msbutton'. What did I do wrong here?

[romperstomper]

it should be msoControlButton not just mosButton.

[ESF]

Great! Replacing mosButton with msoControlButton worked! Now I'll continue my puzzle to avoid double items in the context menu.