LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MB MB is offline
external usenet poster
 
Posts: 53
Default Using TAB vs ENTER for data entry in a protected sheet

Hello experts,

We made a simple form using the lock/unlock function. Then, we protected
the sheet (to only select unlocked cells). When using the TAB key, the
cursor moves in the appropriate order and to each unlocked cell. But, using
the ENTER key, the cursor skips some of the unlocked cells and not in order.

I double checked each cell and they are indeed unlocked. Also, in
Tools/Options/Edit, the "Move selection after Enter" is checked and the
"Down" direction is selected.

Why will it not advance to each unlocked cell when using the ENTER key?

We're using 2003.

Thank you.
MB
 
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 an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
Allowing data entry in protected sheets David Excel Discussion (Misc queries) 1 November 7th 06 09:18 PM
data entry and saves it to sheet 2 YOUNGIN New Users to Excel 1 September 22nd 06 10:21 PM
Sum up columns in different sheet with error check zeyneddine Excel Discussion (Misc queries) 13 July 10th 06 01:21 PM
Protected Row-Oriented Data Entry Paul Excel Worksheet Functions 2 January 20th 06 06:00 PM


All times are GMT +1. The time now is 12:20 AM.

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

About Us

"It's about Microsoft Excel"