I am shifting from using text box to enter data as it created problems with data being spread to other cells occationaly but could not figur out what is the problem. i do not have full proff code and its unreliable.
i am preventing entry in one column by setting the column width to 0. Also noticed that focus is not set to hidden column when value of check1 is set to hide colums . this should solve my problem of preventing focus with arrow keys but need confirmation if this is full proof.