Data Entry Cells

[FRED_SHEET]

I am designing a Microsoft Excel Worksheet where the userwill enter integer values into five different cells (data input cells whichwill be highlighted in yellow). Two of the five data input cells will haveconditional formatting which will limit the values to a certain range. Depending on the data entered up to 165 othercells will be populated with calculated values. One other cell contains a Macro which will erase the five data entrycells when clicked.
The five data input cells are D13, F13, H13, J13 and O15.
I plan on using written instructions to tell the user to goto the highlighted cells and enter the data.

However, I would like to know when the user clicks on this worksheet canthe cursor be forced to go to D13 and F13 and H13 and J13 and then O15?
I plan on protecting this worksheet and workbook once Ifigure out how to do this maybe that is the answer (I have never done this so I have to research this). I do not want any of the other cells in thisworksheet changed.
Let me know how you would approach data entry for thelimited data entry fields.
Thanks for any help.

 

[JoeMo]

1. Unlock the cells you want the user to access
2. Protect the sheet and a 'Protect Sheet' dialog box opens.
3. In the dialog box, uncheck "locked cells". Check "unlocked cells".

The use will be forced to visit only the unlocked cells.

 

[FRED_SHEET]

1. Unlock the cells you want the user to access
2. Protect the sheet and a 'Protect Sheet' dialog box opens.
3. In the dialog box, uncheck "locked cells". Check "unlocked cells".

The use will be forced to visit only the unlocked cells.

Thank you I will try that! If I unlock the cells in the order I want the user to enter the data will that take care of having the user enter the data in the order listed?

I also have a button which erases the data entered into the data entry cells using a Macro, how does Protecting a sheet impact the use of this button since it really isn't in a single cell?

 

[FRED_SHEET]

I unlock the data entry cells and it is working just fine. However the shape I use to clear the data entry cells doesn't work on a protected sheet. I will post a separate question asking how to make a shape Macro work on a protected sheet.