right-click cell menu only for specific range
Thanks Tom,
I just found that myself and am using it in conjuction with this:
If Not Intersect(ActiveCell, Range("CLI")) Is Nothing Then
--
David M
WinXP - Office2003 (Italian)
"Tom Ogilvy" wrote:
Use the worksheet level beforerightclick event to do it. It has an
argument "Target" which passes in which cell(s) triggered the event. You
can use this to rebuild the CELL menu.
--
Regards,
Tom Ogilvy
"#DIV/0" wrote:
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)
|