Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable autoformat of "true" and "false" text | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |