Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting macro on specific filled cell click | Excel Worksheet Functions | |||
Inserting after specific location on right click menu | Excel Discussion (Misc queries) | |||
click on cell takes you to specific sheet | Charts and Charting in Excel | |||
Right click in cell menu options | Excel Discussion (Misc queries) | |||
right click menu missing in cell | Excel Discussion (Misc queries) |