View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default disable right click menu

Hi JT,

I'm assuming that you've used the Worksheet_BeforeRightClick event. If
that's the case, insert this line of code somewhere in that routine:

Cancel = True

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


JT wrote:
I have a macro where when I right click on a cell, I get a
form to display through a private sub. However, once the
form is closed, the "usual" menu (cut, copy, insert, etc.)
you get when you right click is displayed.

Is there a way to disable the "usual" menu from appearing
on this worksheet only?

Thanks for the help.