Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
Thanks a lot for your help. The public variable is working and I think I figured out why the change event is triggered twice. Despite the Application.EnableEvents = False, the .Undo will trigger another call to _Change because it is executed after the Application.EnableEvents is set back to True. So I used another public variable that I set to False. At the beginning of _Change I check for that and ignore the event if the variable is set to False. Then I set it back to True so that the _Change is "turned back on". The only problem I have not been able to solve, is how I can prevent the dragging of a cell into another cell. The SelectionChange will fire but it would be tricky to figure out that it changed due to a cell being dragged. Thanks again, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CutCopyMode question | Excel Discussion (Misc queries) | |||
CutCopyMode=False does not work | Excel Discussion (Misc queries) | |||
Cutcopymode problem | Excel Programming | |||
Does anyone know how to programmatically disable Application.xlcut | Excel Programming | |||
CutCopyMode = False | Excel Programming |