Protected sheet, On Enter moves next. Can I stop this?
 

Hi there,

I have a protected Excel Worksheet. Only specific cells are unlocked
for data entry. The behavior for protected sheets on enter is to move
to the next unlocked cell. Is there any way to make the move next not
happen? (I have that box unchecked in Tools|Options.)

I am not opposed to writing code that preserves the current cell and
goes back to it if this is my only solution.

Thanks,

Erika

Protected sheet, On Enter moves next. Can I stop this?
 

Go to VBA window, double click on desired worksheet and paste this
code:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Select
End Sub


This is a procedure that works for this specific sheet only. Of course
you can paste to other sheets too. It selects a cell after its value
is changed. When you press enter focus remains on the cell you just
changed. With second enter you proceed to next unlocked cell





On Oct 26, 9:04 pm, misseill wrote:
Hi there,

I have a protected Excel Worksheet. Only specific cells are unlocked
for data entry. The behavior for protected sheets on enter is to move
to the next unlocked cell. Is there any way to make the move next not
happen? (I have that box unchecked in Tools|Options.)

I am not opposed to writing code that preserves the current cell and
goes back to it if this is my only solution.

Thanks,

Erika

Protected sheet, On Enter moves next. Can I stop this?
 

Thank you so much.

Any idea why this is the standard behavior? It doesn't seem intuitive
to me.

On Oct 26, 3:26 pm, "www.exciter.gr" wrote:
Go to VBA window, double click on desired worksheet and paste this
code:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Select
End Sub

This is a procedure that works for this specific sheet only. Of course
you can paste to other sheets too. It selects a cell after its value
is changed. When you press enter focus remains on the cell you just
changed. With second enter you proceed to next unlocked cell

On Oct 26, 9:04 pm, misseill wrote:



Hi there,

I have a protected Excel Worksheet. Only specific cells are unlocked
for data entry. The behavior for protected sheets on enter is to move
to the next unlocked cell. Is there any way to make the move next not
happen? (I have that box unchecked in Tools|Options.)

I am not opposed to writing code that preserves the current cell and
goes back to it if this is my only solution.

Thanks,

Erika- Hide quoted text -

- Show quoted text -

Protected sheet, On Enter moves next. Can I stop this?
 

I can only assume it is a bug of Excel. They forgot to apply that
Tools/options setting for protected sheets.

Best



On Oct 27, 5:13 pm, misseill wrote:
Thank you so much.

Any idea why this is the standard behavior? It doesn't seem intuitive
to me.

On Oct 26, 3:26 pm, "www.exciter.gr" wrote:



Go to VBA window, double click on desired worksheet and paste this
code:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Select
End Sub

This is a procedure that works for this specific sheet only. Of course
you can paste to other sheets too. It selects a cell after its value
is changed. When you press enter focus remains on the cell you just
changed. With second enter you proceed to next unlocked cell

On Oct 26, 9:04 pm, misseill wrote:

Hi there,

I have a protected Excel Worksheet. Only specific cells are unlocked
for data entry. The behavior for protected sheets on enter is to move
to the next unlocked cell. Is there any way to make the move next not
happen? (I have that box unchecked in Tools|Options.)

I am not opposed to writing code that preserves the current cell and
goes back to it if this is my only solution.

Thanks,

Erika- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -