Copy Cell and Paste in Same Column Only

A

April

I have a spreadsheet that is protected from allowing users to copy and paste
in the spreadsheet as to prevent pasting cells over other with certain
formats. Is it possible for a user to copy a cell and paste within the the
same column (not including the header). This is the code is have to prevent
them from copying and pasting in general:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Application.CutCopyMode = False
Case Is = False
MsgBox "You can not copy and paste."
End Select
Application.CutCopyMode = False
Application.CellDragAndDrop = False

End Sub

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent copy and paste in one column 3
Change a great number of words in word files, with a macro as short as possible. 5
Having difficulty copying and pasting on VBA 3
Word macro that can call cells out of Excel for a find and replace 0
Disable Cut/Copy/Paste in Excel 2010 0
hidden rows, column copy-paste 0
Formatting and copy or copy and formatting ?? 2
Copy columns and paste with blank column between 5

Top