View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
#DIV/0 #DIV/0 is offline
external usenet poster
 
Posts: 30
Default right-click cell menu only for specific range

Is there a way to get a personalised right-click menu for a named range and
the standard menu for anywhere else ?
I'm changing the cell menu through Workbook_Activate and I guess an "If"
regarding the ActiveCell could do it. What's the best way to say "if the
active cell is inside this range, do A. Otherwise do B (or do nothing)"

--
David M
WinXP - Office2003 (Italian)