This workbook has Module One having Macro to add Menu to Right Click Command.
All Contextmenu Control under Command Bars appears above Cut, Copy etc inbuild Microsoft Office Menu items
Currently it is not grouped and such custom command bars are expanding, hence need to have it under Sub-menu, and seniors help sought.
Help -
How Do I make Three Major CommandBars Say -
1) PrepareData
2) Report Data
3) CustomReport
Such that existing Command Bars appear under item 2) Report Data, and how do I group similar Command bars to call upon Macro that would appear
under item 1) Prepare Data, and 3) CustomReport
So, when I Right Click in Excel, above Cut, Copy etc in-built command bars, only above three items appear at top, and rest of other are grouped under 2) and son on
Is there also a way to hide the default, Cut, Copy, Paste, Insert…., Delete….., Clear Contents…., Filter….., Sort…, Insert Comment…., Format Cell…., Pick from Drop Down List, Define Name…., and Hyperlink….
Something like
This Custom Right Click Menu should appear have control only in the current workbook only.
Thanks
Bookmarks