MoveAfterReturn does not function on protected sheet

[TryingToLearn]

Excel 2016 on Win10
Activating the workbook turns moveafterreturn to false & immediate window confirms this is correct. for coding on the sheet to work properly the cell being changed needs to be the active cell.

If the sheet is not protected, all works fine. If the sheet is protected, all cells except the working row are locked HOWEVER,
the cursor moves to the next cell after hitting return. I have exported code to a new workbook with the same results. I've found several threads but no solution. What am I missing?

Private Sub Workbook_Activate()
    Dim Lrw
    'Record MoveAfterReturn settings
    Range("MvTF") = Application.MoveAfterReturn
    Range("MvDirec") = Application.MoveAfterReturnDirection
    Application.MoveAfterReturn = False     'Ensure no moves
    With Sheets("log")
        .Activate
        .Protect UserInterfaceOnly:=True
        .EnableSelection = xlUnlockedCells
        .Cells.Locked = True          'Lock all cells
        'Unlock next line to be used
        Lrw = .UsedRange.Rows.Count + .UsedRange.Row - 1
        Lrw = Lrw + 1
        Range(Cells(Lrw, Range("dt").Column).Address & ":" & Cells(Lrw, Range("entryno").Column).Address).Locked = False
        Cells(Lrw, Range("dt").Column).Select 'move to first entry item
    End With
End Sub

 

[starl]

Why does a specific cell need to be active for code to work? If you need to read/write a cell, you can specify it - not use Selection or ActiveCell.

Anyway, I tested the code and MoveAfterReturn appears to be working correctly - that is, it is completely turned off

 

[TryingToLearn]

Thank you for your response Tracy. As I enter data into the sheet, it is the active cell that is the focus of the code. Once I hit return, it is no longer the active cell if it advances to the next unprotected cell. Any other thoughts are appreciated on how to correct this.

 

[starl]

Why not use Events?