title: How to restrict cut copy past option for entire column
body: <p>Per attached excel sheet, user should not able to cut copy and past for column &quot;B&quot; dropDown list.
  User should able select data only from available dropDown list option</p>
  <p>Sample Excel sheet with dropList
  <a href="https://i.stack.imgur.com/AtfHW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AtfHW.png" alt="Sample Excel sheet with dropList" /></a></p>
  <p>Could you please help me for the VBAMacros code.
  Have tried multiple option, but no luck.</p>
  <pre><code>  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If Not Application.Intersect(Target, Range(&quot;B:B&quot;)) Is Nothing Or 
    Not Application.Intersect(Target, Range(&quot;C:C&quot;)) Is Nothing Then
          If Target.Cells.Count &gt; 1 Then
                  Application.EnableEvents = False
                         Application.Undo
  </code></pre>