View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bridges Bob Bridges is offline
external usenet poster
 
Posts: 108
Default how can I disable "cutting cells" and "drag and drop "in excel ?

Interesting: You want to leave some cells unprotected so a user can modify
the contents with keystrokes (eg typing "3" into it), and you don't mind
"delete" and "paste", but you want to prevent (drag-and-)drop and "cut"?
Guess I'd better not ask why. Someone else here may know better, but I'm
thinking if this can be done at all it'll have to be with a VBA macro, say a
big KeyPress monitor that intercepts just the changes you want and refuses to
respond to them....if that's even possible. If so, you should post this
question on the Excel Programming forum.

--- "mwoody" wrote:
I need to disable the "cut" and the "drag and drop" functions on all
worksheets in the entire workbook. However, I want the copy and paste
function to remain by using the "right click" on the mouse. All sheets in the
workbook are protected so the cells in question are "unprotected cells".