I've got a spreadsheet where the range of cells that have values/formulas in it are unprotected and the rest of the cells are protected. Because of this, when I hit enter in a cell that's in the last row of the unprotected cells it will go up to the top of the sheet because it's going down but because the cell below it is protected and can't be selected it selects the top cell in the next column. I unchecked "After pressing Enter, move selection" in the Options, but because it's a protected sheet it ignores that and still moves the selection down after pressing Enter. Is there any sort of VBA code I can use to make it so that when the sheet is protected and I hit Enter that the selection doesn't move at all? Any help would be appreciated!!