Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying and pasting on the whole worksheet. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Columns("H:H")) Is Nothing Then Application.CellDragAndDrop = False Application.CutCopyMode = False Else Application.CellDragAndDrop = True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you prevent Copy-Paste from changing formatting without macros | Excel Discussion (Misc queries) | |||
Prevent Copy/Paste Q | Excel Programming | |||
Unable to prevent copy/paste of protected worksheet into new docum | Excel Programming | |||
How to prevent copy/paste of cell with validation? | Excel Programming | |||
prevent the copy and paste function | Excel Discussion (Misc queries) |