Thread: Protected cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SmartyPants SmartyPants is offline
external usenet poster
 
Posts: 26
Default 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.