I expect this is probably an easy one to sort out......but it's got me stuck!

I have a sheet with a macro that protects and unprotects depending on what's happening on the sheet.

For some reason the cell selection moves whenever I hit return. The problem is, when I look at Options, the "Move Selection After Enter" is off! Now if I unprotect the sheet, the cell selection stops moving when I hit return.

In a nutshell, the "Move Selection After Enter" is set to off, but when the sheet is protected, the selection still occurs after hitting return. When the sheet is unprotected, everything is ok!!

Hi

I think you need to make sure that 'Select Locked Cells' is ticked (or the VBA equivelant) when you protect the sheet.

ie like
or similar

MTB

Mike
Thanks for that, I think you are probably right. I should say now that I got so frustrated with the problem, I am now using a form to control input onto the worksheet!!
Thanks anyway.
Paul