G
Guest
XL help not much help. I need to change the tab order for a protected
worksheet. When the sheet is unprotected the tab key moves from left to right
as expected. When the sheet is protected the tab key moves between column A
and B only. I need to change this to move between two different columns. Most
of my data is entered in columns F and G so I want the tab key to move
between these columns when the tab key is pressed. When I need to move to the
next row I use the enter key and it moves the selection down as expected but
when I press tab again the selection changes to column A again. What can I do
to correct this?
Also columns A, B, F and G are unprotected so data can be entered by the
user however column A will only change for each calander year. Column B is
the discription of the work being done and F and G are the sign on and sign
off times for the day.
worksheet. When the sheet is unprotected the tab key moves from left to right
as expected. When the sheet is protected the tab key moves between column A
and B only. I need to change this to move between two different columns. Most
of my data is entered in columns F and G so I want the tab key to move
between these columns when the tab key is pressed. When I need to move to the
next row I use the enter key and it moves the selection down as expected but
when I press tab again the selection changes to column A again. What can I do
to correct this?
Also columns A, B, F and G are unprotected so data can be entered by the
user however column A will only change for each calander year. Column B is
the discription of the work being done and F and G are the sign on and sign
off times for the day.