I have a block of about 500 cells that require text input (mainl
numbers, but also some plain text). I would like the user to only b
able to input the assigned values one at a time without alterin
anything else.

Right now the entire spreadsheet is password protected with th
exception of these 500 cells. However, I have found that the autofil
and "drag and drop" have allowed users to modify the formating on th
sheet.

How can this be prevented?

I also deactivate drag and drop, and that only deactivates the comman
on cells that are protected. Please help

--
Message posted from http://www.ExcelForum.com