Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change font when sheet is protected | Excel Discussion (Misc queries) | |||
"change order form" | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How do I change the order of the legend entries? | Charts and Charting in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |