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

M

misseill

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
 
W

www.exciter.gr

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
 
M

misseill

Thank you so much.

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

www.exciter.gr

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

Best
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top