View Single Post
  #1   Report Post  
dvonj
 
Posts: n/a
Default How to change the tab order for a protected worksheet

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.