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
Bookmarks