title: Is there a VBA macro in excel that can enable copying and pasting in a " macro enabled excel worksheet "?
body: <p>I have an Excel Macro enabled Worksheet that contains a pivot table. I made a small macro in VBA to automatically refresh the pivot tables here is it:</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  PivotTables("data").RefreshTable
  End Sub
  </code></pre>
  
  <p>Now the problem I am facing is that when I try to do a normal drag fill or copy and paste it doesn't work normally. However, for the drag and fill I found a VBA code that solved the problem which is this:</p>
  
  <pre><code>Application.CellDragAndDrop = True
  </code></pre>
  
  <p>i tried the same syntax with the copy and paste using </p>
  
  <pre><code>Application.CutCopyMode = True
  </code></pre>
  
  <p>But it didn't work I can only copy but can't paste-like the cell get highlighted but when I click anywhere else to paste it's gone so is there anything I can do to fix it. </p>
  
  <p>Thanks in advance </p>