I have found the following line of code quite helpful in a situation like yours
where you are using a worksheet as a kind of "data entry form" with entry
cells in various locations as opposed to in a single column:

ActiveSheet.EnableSelection = xlUnlockedCells

It requires all cells to be locked except the "Entry cells"
AND the sheet must be protected.

HTH

"Hugh" not.com" wrote:

Hope this makes sense

User enters number in B3. Formula in C3 then shows "x". User then
Tabs or uses right arrow to go to D3.

Is there a way to arrow or Tab directly from B3 to D3 so that data
intended for D3 does not get inadvertently entered in C3?

Validation &/Protection keeps out entries, but involves the hassle of
clicking out of the error message.

This is a worksheet w/large amounts of entry. It is difficult to keep
track of where you are on the sheet because you are following the
information that is on your desk, instead of on the screen.

Tried recording a macro that hides col C when a cell is selected in col
B, but cant figure out how to make it work automatically.

Any help gratefully accepted