Hi all,
Please, I need to know how to skip an already filled cell on a excel
worksheet when hit enter or arrow when moving across existing filled
worksheet.
Thank you in advance

I would think you would need a Worksheet_Change macro running all the
time protecting and unprotecting the sheet as you make changes. As you
exit a cell, the macro would unprotect the sheet, check to see if the
cell you WERE in has a value greater than blank or 0, and if so, setting
the protection value for that cell, then reprotecting the sheet.

Your protected sheet could only let you select unlocked cells, so as
your cursor moves around, it would only rest in empty cells.


--
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

Hi JBeaucaire,
Thank you so much for your reply,
I still need more info, my specific question is as follow:
when i make a worksheet, i need to skip some specific cells as when i move
across the cells using "enter" or "Arrow" bottons, the specified cell should
be skiped as constant value, in another word, i need to skip it when moving
across the cells

"JBeaucaire" wrote:


I would think you would need a Worksheet_Change macro running all the
time protecting and unprotecting the sheet as you make changes. As you
exit a cell, the macro would unprotect the sheet, check to see if the
cell you WERE in has a value greater than blank or 0, and if so, setting
the protection value for that cell, then reprotecting the sheet.

Your protected sheet could only let you select unlocked cells, so as
your cursor moves around, it would only rest in empty cells.


--
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

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

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