how to skipp an already filled cell when moving across excel sheet

A

Alexmcghad

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
 
J

JBeaucaire

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

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

Alexmcghad

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
 
J

JBeaucaire

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

If you want access to columns B:C:D, highlight them, press CTRL-1 t
open the Format Cells box, click on Protection, and UNCHECK th
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 th
box that allows selection of locked cells

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

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