Protected cells
I have a worksheet with many protected cells.
In the middle, I have many cells altogether that can accept input.
My problem is, someone keeps dragging the unlocked cells around WITHIN
the unprotected area, and it is screwing up the formulas.
How do I limit what the users can do with the unlocked cells?
Most importantly, I would like to keep them from copying and pasteing,
as well as moving, cells.
All I want them to be able to do is select the cell, and enter some
data. That's it.
|