F
fh217
Hi
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it becomes the first
column next to the frozen columns ( column 3 ), also if the user
back tabs the sheet would shift to the right. I am doing it now by
setting the columnwidth of the column being tabbed out of to a
width of 10 and when it gets focus resetting the columnwidth back
to its normal size. Is there a way to do this without setting and
resetting column widths? I now I can also change the order of
the columns but I was trying to avoid that. Thank you in advance
for your help.
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it becomes the first
column next to the frozen columns ( column 3 ), also if the user
back tabs the sheet would shift to the right. I am doing it now by
setting the columnwidth of the column being tabbed out of to a
width of 10 and when it gets focus resetting the columnwidth back
to its normal size. Is there a way to do this without setting and
resetting column widths? I now I can also change the order of
the columns but I was trying to avoid that. Thank you in advance
for your help.