Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using TAB vs ENTER for data entry in a protected sheet | Excel Worksheet Functions | |||
Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
Tab/Enter key moves to next available cell in protected worksheet | Excel Worksheet Functions | |||
Excel - cursor moves to other cells after I enter data, without h. | Excel Discussion (Misc queries) | |||
My entire sheet moves instead of the cursor. What to do? | Excel Discussion (Misc queries) |