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

On Aug 24, 7:52 pm, Steve Peel
wrote:
You can disable the "drag and drop" feature in the "Tools" menu under options
- deselect the box labeled "drag and drop". You can also remove the "cut"
icon in the menu bar (the scissors) by selecting "customize" in the "Tools"
menu and drag the scissors out of the menu bar into "Customize". But, as far
as disabling the feature so it is not available in the "Edit" menu or the
"right click" menu???? I can't think of any way outside of trapping it with
VBA code.

You can also remove commands from the Edit menu in Customize. However,
all these are changes to Excel Options, not Workbook Options. So you'd
have to go around to each computer and sabotage it. And a user could
simply put them back, or maybe whine to IT who would fix it.

VBA is the only answer.