Thanks for this. I'm trying to get the active cell to remain the same when
enter is pressed, but in a protected sheet it jumps to the next unprotected
cell. I thought I may have been able to do it with your response below but I
can't get it to work. Can you help with a macro to do this?

"JE McGimpsey" wrote:

One way:

ActiveSheet.Cells(rownum, colnum).Activate



In article ,
Ken G. wrote:

What is the correct vba syntax to use to make a particular cell the active
cell when the row number and column number are known?