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)

right-click cell menu only for specific range
 

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)

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)

right-click cell menu only for specific range
 

Another question arises from what I'm doing: how can I completely clear the
CELL menu before adding my items ?
I'll use the reset command later on.

Do I have to empty the standard menu by calling up the controls one by one
(based on their captions ?) and deleting them or is there a single
all-powerful command ?

--
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)