If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can I disable "cutting cells" and "drag and drop "in excel ?
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". |
#2
|
|||
|
|||
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". |
#3
|
|||
|
|||
how can I disable "cutting cells" and "drag and drop "in excel
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. "Bob Bridges" wrote: 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". |
#4
|
|||
|
|||
how can I disable "cutting cells" and "drag and drop "in excel
And then there are the keyboard shortcuts for cutting and pasting, ie
Shift-Del and Ctl-X for the former and Shift-Ins, Ctl-V and Enter for the latter. Ah, yes, I forgot about the Options checkbox for drag-and-drop. --- "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. --- "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". |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|