The problem is I want to lock some cells and unlock some cells. If I lock
this cell and uncheck the select locked cells then I can't select it, if I
unlock the cell then I can select it but it doesn't ask for the password to
change. I want the users to only select and tab to unlocked cells.

I tried reversing my locked and unlocked but when I go to the protection
part I can either have select locked cells and select unlocked cells checked
or just select unlocked cells checked. It will not let me just check the
select locked cells.

Users will be using tab to go from cell to cell.

"Jay" wrote:

Hi Dwaine -

After you follow the steps for Method 2, you need to protect the sheet. I
neglected to clarify that earlier, but I think this will make it work.

You are offered a button to "Protect Sheet..." at the bottom of the "Allow
Users to Edit Ranges..." dialog box (where you assign a password to the
cell). Alternatively, you can just use the standard "Tools, Protection,
Protect Sheet..." after you've assigned the password to the cell.

Jay