I have a worksheet in which users invoke a macro to append a pre-populated row to that sheet. Some of the cells in the row may then be overwritten, while others contain formulas and are locked.

Each row has more columns than will fit onto a screen and so, if I use the cursor to move along the row, when I reach the end of the row I'm taken to the next unlocked cell. The next unlocked cell might be on the next row or, if there isn't a next row with unlocked cells, then the first unlocked cell on the sheet.

It's not the end of the World, but I'd rather the cursor stay in the active cell if there isn't another unlocked cell in the row.

Would this be possible? And, if so, how please?