'Move Selection after Enter' when sheet is Protected

Here is my problem,

I have a series of user input cells. When the user inputs an questionable value a userform pops up asking if they want to keep the value or reenter. If the user selects 'KEEP', the cell selection should move to the next available cell. If the user selects 'REENTER', the cell in which the value was entered should clear and the selection box should stay put on that cell.

This in and of itself is quite simple. I disabled the 'Move Selection after Enter' option and then added:

Please Login or Register  to view this content.

To move the cell selection upon clicking 'KEEP'. Here's the rub. My sheet needs to be protected to prevent the users from messing with non input cells. When I protect the sheet, the offset still works, but when 'REENTER' is selected, the cell selection moves down a cell. When I protect the sheet, I only allow unlocked cells to be selected.

Why does protecting the sheet eliminate the effects of the MSAE? I have an example workbook attached if you should need any clarification.

Hi kilgrow.jp33

you could unprotect the sheet then add sheet protection

Please Login or Register  to view this content.