Controlling the position in Protected Worksheet
Posted on 2013-11-05
I have protected a sheet that has a number of cells that allow for imputting data. The cells that you input data into are unprotected so as to allow one to navigate from cell to cell and input the data. Here's the question; When you go from one cell to the other, it doesn't go in the correct cell to cell path. Instead, it may go to another unprotected cell further down and not in the natural order. How do you control the cursor to go to the next logical cell?
Thank you in advance,