View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default CutCopyMode is never xlCut!?

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