Can anyone tell me how to protect a user of an excel sheet from dragging cell entries from one cell to the other?
I want the user to be able to enter in figures in the cell but want to prevent him/her from dragging/copying that information anywhere else in the sheet.
I know that there is an option under Tools/Options/Edit/Allow cell drag and drop to remove this facility.
The trouble is this prevents dragging and dropping from every workbook and I just want to limit this function in this one specific one.
Any help would be appreciated!!