title: VBA to paste data on the cells without changing format
body: <p>I have a Macro-enabled protected workbook where the user is allowed to edit only a certain fields or rows(150 to 200) on all sheets. </p>
  
  <p>The concern is I am not able to set the formatting on the editable fields, so when the user copy anything on the fields it takes the source format and it clutters the sheet.</p>
  
  <p>I tried to use the following but that didn't help. Please suggest.</p>
  
  <pre><code>Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
      On Error Resume Next
      Target.PasteSpecial xlPasteValues
      Application.CutCopyMode = True
  End Sub
  </code></pre>