I have a worksheet only want other people to be able to answer the questions.
How can I do that?

I assume you mean you want users to only be able to enter data in specific
cells. If so, select the cells you want them to be able to access and unlock
them.
FormatCellsProtection Unselect Locked.
Once you have completed your sheet, got to ToolsProtectionProtect Sheet
and enter a password. Until the sheet is unprotected (needing the password),
only the unlocked cells can be edited.
--
Ian
--
"Misty" <Misty @discussions.microsoft.com wrote in message
...
I have a worksheet only want other people to be able to answer the
questions.
How can I do that?

Misty

Re-read your posting and you'll probably see that it has a great lack of detail
included.

Try again with a better description of your needs.


Gord Dibben MS Excel MVP

On Fri, 3 Feb 2006 10:29:59 -0800, "Misty" <Misty @discussions.microsoft.com
wrote:

I have a worksheet only want other people to be able to answer the questions.
How can I do that?