Thread: Protected Cell
View Single Post
  #1   Report Post  
DME
 
Posts: n/a
Default Protected Cell

I have an input sheet that user input data and it calculates a sales price.
I have locked the worksheet and uprotected the cells where the user needs to
input information. My question, is there a way that makes it only possible
for the user to have access to the unlocked cells. In other words, when the
user inputs info into a certain cell, the cursors jumps to the next unlocked
cell. Basically I just want to give them access to the unlocked cells.