LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sp2 tester
 
Posts: n/a
Default Order of selecting unprotected cells

I was wondering if anyone could assist me with an Excel 2003 problem I am
trying to solve?

I have a worksheet which has majority of it's cells protected. There are
only 5 cells which the user is allowed to select and enter information. The
first 2 cells are directly underneath each other eg: C6 + C7. I have another
2 cells which are unprotected B8 + B9. The final cell which is unprotected is
D5. The end user needs to enter information in cells C6 and C7 first, then
enter information into B8 and B9 second, then finally enter information into
D5. While using the enter key, cells C6 and C7 work fine, but the problem is
that Excel 2003 then jumps to cell D5 instead of cells B8 and B9. Does anyone
know how I can tell Excel to jump from cell C7 to B8 that will work in older
versions of Excel as well?

Thanx
 
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
Selecting Cells with Shift Key Jaymndad Excel Discussion (Misc queries) 5 June 6th 05 10:46 PM
Help me! There is problem with cells view... :-) Excel Discussion (Misc queries) 1 April 28th 05 01:16 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 11:13 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"