Fix Copy and Paste Blocked by an Excel SelectionChange Macro
Question details
Allow copy and paste while retaining a worksheet macro that recalculates when cells in columns G:K are selected.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A Worksheet_SelectionChange event recalculates the worksheet when the selection intersects columns G:K.
- Observed behavior
- The recalculation triggered by the selection event interrupts copy and paste operations in the affected range.
Locate the worksheet that contains the SelectionChange event and confirm that the workbook is saved in a macro-enabled format, such as .xlsm. Enable macros only if you trust the workbook.
Skip the SelectionChange calculation during copy or cut
Check Excel's CutCopyMode before recalculating so an active copy or cut operation is not interrupted by the event.
In Excel, open Developer > Visual Basic. In the Project pane, find the affected workbook and double-click the worksheet that contains the Worksheet_SelectionChange procedure.
In the worksheet code window, update the existing Worksheet_SelectionChange procedure to check CutCopyMode before the calculation. For the event described here, use: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = xlCopy Or Application.CutCopyMode = xlCut Then Exit Sub If Not Intersect(Target, Me.Range("G:K")) Is Nothing Then Me.Calculate End Sub If the existing event contains other actions, add the CutCopyMode check before the calculation rather than creating a second SelectionChange procedure.
Save the workbook as an .xlsm file, return to the worksheet, and copy or cut cells in columns G:K. Select a destination and paste, then select a cell in G:K outside an active copy or cut operation to test the calculation.

Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. It can help you move routine spreadsheet work between applications, but it does not fix Excel's VBA event behavior; verify macro compatibility before migrating a macro-dependent workbook.

Frequently Asked Questions
Why does selecting a paste destination interrupt copying?
Selecting a destination fires Worksheet_SelectionChange. If that event recalculates the worksheet while Excel is in copy or cut mode, it can interrupt the operation. Check Application.CutCopyMode before running the calculation.
Where should I put the CutCopyMode check?
In Developer > Visual Basic, open the affected worksheet's code module and place the check near the start of its existing Worksheet_SelectionChange procedure, before the calculation.
Will the macro still recalculate when I select columns G:K?
Yes, when Excel is not in copy or cut mode. If copy or cut mode is active, the procedure exits and skips that calculation.
How do I keep the macro after saving the workbook?
Use File > Save As and choose Excel Macro-Enabled Workbook (.xlsm). When reopening the file, enable macros only if you trust its source.




