By default when a work sheet is protected all cells are locked.

Select cells in which users are to enter data.

FormatCellsProtection. Uncheck the "locked" option.

Now ToolsProtectionProtect Sheet.

Set the options you wish users to have then provide a password and OK.

Note: sheet passwords are easily cracked.


Gord Dibben Excel MVP


On Wed, 18 May 2005 10:37:08 -0700, BLW wrote:

I am working on a project where a user will be using sheet1 that uses
information on sheet2. Is there anyway for me to make it where the user
cannot accidentaly delete or tamper with the information in sheet2. Also, I
am will be using the Vlookup function on some of the cells in sheet1; is
there anyway for me to lock in that equation in that cell at all times, so
that if the user decides they mess up and they delete the text in that cell,
it doesn't delete the equation??