Hi John,
Just curious why you're modifying the default popup menu instead of
creating your own and substituting it for the built in menu. This would
solve the problem entirely.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"John A Grandy" wrote in message
...
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 !