BigWill5112
asked on
Prevent users from dragging a cell contents to a new location.
Is there a way with a macro that I can disable users from selecting a cell and then dragging it to a new location. It is screwing up my formulas. I'm sure I'm not the first person to experience this. How do you over come this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is sort of what I needed but I didn't want it to be applicable to the application, just the particular workbook.
I was also aware of protecting sheets.
I think I will be really happy with the below.
http://vbadud.blogspot.com/2008/04/disable-drag-drop-of-cells-in-excel-vba.html
I was also aware of protecting sheets.
I think I will be really happy with the below.
http://vbadud.blogspot.com/2008/04/disable-drag-drop-of-cells-in-excel-vba.html
Note, by default, when you protect a worksheet, all the cells on the worksheet are locked, and users cannot make any changes to a locked cell. Before you protect a worksheet, you will need to unlock all the cells you want users to be able to change or enter data in. In your example, you would unlock all cells except the one you don't want moved. To unlock all cells except one:
1. Click on the tab of the worksheet that you want to protect and select all cells (CTRL-A).
2. Right-click over the selected worksheet --> select Format cells --> Protection tab --> uncheck the Locked checkbox --> click OK.
3. Select the cell you want to protect --> right-click the cell --> select Format cells --> Protection tab --> check the Locked checkbox --> click OK. (At this point you have unlocked everything except the cell you want to protect.)
4.On the Review tab, in the Changes group, click Protect Sheet.
5.In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.
6.In the Password to unprotect sheet box, type a password --> click OK, --> retype the password to confirm it click OK. The password is optional.
Hope this helps.