hi,
can anyone point out where i'm wrong on my Worksheet_Change 1st paragragh? I just need the target cell AC4 to stay put in its cell when no value is entered but the user does hit ENTER key anyway. The first paragragh doesn'tseem to be achieving this. Only if there is data input jump to Y4.
(I need this mainly because once in protected sheet mode, whenever user hits enter key, no matter if AC4 has data or not, the screen always oddly pans itself to right side out of main worksheet view, i think it may be drawn there by another faraway unprotected cell that doesn't need daily inputs)
cheers
Stewart.
Bookmarks