Thank you so much, it was very helpful
"JBeaucaire" wrote:


You can use the Protecting Sheet idea manually. If you have cells you
NEVER want to have your cursor stop in, unlock the cells (columns) you
want to allow access to, then Protect your sheet.

If you want access to columns B:C:D, highlight them, press CTRL-1 to
open the Format Cells box, click on Protection, and UNCHECK the
protection box.

Now repeat that for other columns you DO want to have users access.

When done, click on Data Protection Protect Sheet, and UNCHECK the
box that allows selection of locked cells.

When the sheet is locked, the user can only move from unlocked cell to
unlocked cell.

If you unlocked B:C:D and left E:F locked, then unlocked G:H:I, then
when you tab across a row, it would jump from column D to column E.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48899