When you right-click on a cell, Excel provides you with a feature-rich Context menu that allows you to do any number of things. You may want to add some features to that Context menu, particularly if they are features you use often.
Problem:When you try to change ContextMenu('Cell') (Right Click in a cell) sometimes you can see how the context menu changed, and sometimes you don't.
You ever wonder why? I'll share it so I can save some other newbie's time.
For an example Ron de bruin 'How to build & change ContextMenu'
Community♦
CharlieCharlie
1 Answer
Reason:Excel has different ContextMenu with the same name (in this case Cell) that are only shown in specific situations. For instance, depending on the current layout mode (Page Break Preview or Normal) it will call different Menu.
Solution:Credit goes to MrExcel.
Set different commandbar control as:
Now you only need to change both menus and you will be able to see the changes no matter in which mode the user is working on.
CharlieCharlie
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.