View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default A question about locking or protecting a worksheet

Unlock the cells you want them to be able to change
(Format/Cells/Protection), then protect the sheet.

In article ,
Meenie wrote:

Hi!
I have a worksheet that others need to input data into. I don't want them to
be able to change the size of the cells. They keep dragging the cells into
different sizes causing the thing to print off the page. (They say they don't
know how they did it, lol)
How can I protect the sheet so they can enter their info but not change the
cell sizes?
Thanks, Meenie