Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell and Paste in Same Column Only
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a column and paste to another tab to save the data for each m | Excel Discussion (Misc queries) | |||
Why won't the copy/paste from PDF retain the row/column in excel? | Excel Discussion (Misc queries) | |||
Copy contents in a row and paste in a column | Setting up and Configuration of Excel | |||
Copy/Paste Macro and Column Sizing | Excel Programming | |||
Copy Column and Paste | Excel Programming |