LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using TAB vs ENTER for data entry in a protected sheet MB Excel Worksheet Functions 3 January 12th 07 10:35 PM
Down arrow moves cursor to top of worksheet when sheet protected Bill Williams Excel Worksheet Functions 0 April 29th 06 06:37 PM
Tab/Enter key moves to next available cell in protected worksheet LMSCHIER Excel Worksheet Functions 1 September 19th 05 10:08 AM
Excel - cursor moves to other cells after I enter data, without h. mitzi Excel Discussion (Misc queries) 2 March 2nd 05 04:22 AM
My entire sheet moves instead of the cursor. What to do? Trying Excel Discussion (Misc queries) 2 February 20th 05 05:41 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"