Protected cells

[SmartyPants]

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.

 

[MarMo]

Hi there ,
You could protect your sheet and select the things users can do.
in the menu click Tools / Protection / Protect Sheet
You'll get a popup screen where you can put a password and select the items
to allow or not allow what usres can do.
MAKE SURE YOU SAVE YOUR PASSWORD SOMEWHERE YOU'LL FIND IT BACK !!!

Before you protect your sheet move all your cells to the correct place , or
start a new sheet.
Select the entire sheet ( left top corner - between A and 1) rightclick in
the sheet and select format cells.
(Standard the cells are locked - but do it anyway to make sure)
Select the tab protection and check "locked".
Now all cels are locked (when you protect your sheet.)
Select every cell you need to unprotect ( where the user can input)
right-click on these cells and uncheck the "locked" checkbox in the
protectiontab.
If all that is OK , proceed with the above protection of your sheet.

Hope this helps
MarMo