Dr Fear
06-26-2009, 05:15 AM
I'd like to usurp the normal behaviour for filling cells (down or up), that is, I think I need to trap the event that user has selected a cell then moved the cursor to the bottom right corner and watched it change to a plus sign.
But that does not seem to be a trappable event, at least, there is no event handler for it in the usual drop-down list or anywhere I can see in help or web search.
If I can't do anything else, I would at least like to be able to stop users from doing this at all. (But - I can't just disable events, I need all the usual event traps active.)
Failing that, does anyone know the name of the menu that follows right-click select-for-fill, and if I modify that right-click menu, and use it to call the function I really want, can I prevent the subsequent fill?
But the ideal I am really hoping for is to allow a user to do go through the entire process of selecting a range with the plus sign, using either right or left click and drag, indicating it would be filled, but then usurp the .FillDown method itself to do something other than .FillDown.
Any pointers?
But that does not seem to be a trappable event, at least, there is no event handler for it in the usual drop-down list or anywhere I can see in help or web search.
If I can't do anything else, I would at least like to be able to stop users from doing this at all. (But - I can't just disable events, I need all the usual event traps active.)
Failing that, does anyone know the name of the menu that follows right-click select-for-fill, and if I modify that right-click menu, and use it to call the function I really want, can I prevent the subsequent fill?
But the ideal I am really hoping for is to allow a user to do go through the entire process of selecting a range with the plus sign, using either right or left click and drag, indicating it would be filled, but then usurp the .FillDown method itself to do something other than .FillDown.
Any pointers?