When you protect the worksheet it does not offer an option to stop users from
moving cells. I need them to be able to enter data in but not be able to move
the cell itself. Plus I was specifically wondering how to do this in VBA,
programattically, which I could not figure out how to do on my own. How would
one protect the worksheet with code?

"bigwheel" wrote:

Protecting the worksheet should provide the solution to your problem

"Devin Linnington" wrote:

I am making a workbook with sheets that have references to other sheets in
that workbook. The problem is that when you move a cell you also change the
other cells that reference to that one. This screws up my entire workbook, so
I need a way to turn off the ability to move cells. I looked around a bit an
haven't found any options, so what I need is a way to turn on/off the
movement of cells from within a VBA program. If anyone knows the command I
would love to know what it is.
Thanks,
Devin L.