CutCopyMode with Calculation=xlCalculationManual

**foxguy** · 02-18-2011, 10:49 PM

I have one sheet where I want to turn off Calculation during SheetSelectionChange. But I don't want to lose the CutCopyMode and marching ants.

Setting App.Calculation also turns off CutCopyMode

Please Login or Register  to view this content.

**watersev** · 02-19-2011, 07:43 AM

a bit strange question, at first the specified code is not the selectionchange event code, secondly this event occurs when the selection changes on a worksheet and gives you changed range address. So turn off calculation and do whatever you need with the result range.

**royUK** · 02-19-2011, 08:12 AM

You haven't entered the Worksheet event code by selecting the correct event in the drop down of the VB Editor.

Copying would be cancelled by changing the selection and performing an action on a different range, unless it is a paste operation

**foxguy** · 02-21-2011, 04:50 PM

Hi Roy;

I'm trying to restore the range that has the marching ants around it. When Calculation is set to manual it turns off CutCopyMode and removes the marching ants. I can reset CutCopyMode but I want to know how to restore the marching ants.

**foxguy** · 02-21-2011, 04:55 PM

Hi watersev;

I guess I didn't explain myself. When I'm working in the worksheet I want to do a copy and paste. I do the copy and Excel sets the marching ants, then I change the selection to do the paste, but my Worksheet_SelectionChange() event removes the marching ants when it sets calculation to manual. I'm trying to reset the marching ants so that I can do the paste.

Right now the only thing I can think to do is to turn "EnableEvents" off, do my cut and paste and then turn "EnableEvents" back on.