View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spencer Spencer is offline
external usenet poster
 
Posts: 29
Default disable cut and paste

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub

in case anyone searches.

"Spencer" wrote:

is there a way to disable the ability for a user of my app to select a cell
where the cursor changes to a 4 arrow and the cell can be moved to another
location. the macro recorder called it selection.cut and selection.paste.
is there a way to disable this globally across the entire sheet?