Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i trap the Worksheet_BeforeRightClick() event and modify the
Application.CommandBars("Cell") menu, making some of the built-in CommandBarControls invisible and adding some new CommandBarControls .... this technique works fine (right-clicks bring up the customized menu) EXCEPT if a range is selected on the sheet and the right-click is on a cell in the selected range: in this case, the default Cell menu shows up ... the Worksheet_BeforeRightClick() event is still being triggered, and i can still single-step through the code which modifies the Cell menu with no errors ... programatically, nothing occurs which is any different than the no-selection case ... but the Cell menu is unchanged from its default state ! very bizarre behavior ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
BeforeRightClick | Excel Worksheet Functions | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
How do I link one cell to a range of cell with a drop-down menu? | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |