I cannot get the lock specific cell function below to work:

1. Select entire worksheet by clicking the Select All button
2. Click Cells on the format menu, click the Protection Tab, and clear the
LOCKED check box.
3. Select the cells you want to lock and repeat step 2, but this time select
the LOCKED check box.
4. Go to tools menu, point to Protection, and click Protect Sheet. Then OK.

It locks the entire worksheet instead of the few cells I've locked
individually.

The worksheet will be protected, but you should be able to change the cells that
you unlocked.

What happens when you try changing a value in that cell?

What makes you believe that it's not working correctly--what are you doing and
what happens when you do it?

Lisa wrote:

I cannot get the lock specific cell function below to work:

1. Select entire worksheet by clicking the Select All button
2. Click Cells on the format menu, click the Protection Tab, and clear the
LOCKED check box.
3. Select the cells you want to lock and repeat step 2, but this time select
the LOCKED check box.
4. Go to tools menu, point to Protection, and click Protect Sheet. Then OK.

It locks the entire worksheet instead of the few cells I've locked
individually.

--

Dave Peterson