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.

Create a couple of ranges (INSERT / NAME / DEFINE) containing only the cells
for the various situations you want.
For each situation,
(1) unprotect the worksheet
(2) highlight the whole worksheet, then...
FORMAT / CELLS / PROTECTION, make sure the 'Locked' check box is checked.
(3) select the appropriate range from the NAME BOX...
FORMAT / CELLS / PROTECTION, make sure the 'Locked' check box is unchecked.
(4) protect the worksheet
HTH,
Gary Brown


"dvonj" wrote:

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.

Thanks GB don't know why I could'nt figure that one out. I tried everything
but that and the Help file had nothing I could find to help. So thanks much.
I am going to demonstrate the wookbook for my boss hopefully this afternoon
and that was the last thing I needed to get working.

"Gary Brown" wrote:

Create a couple of ranges (INSERT / NAME / DEFINE) containing only the cells
for the various situations you want.
For each situation,
(1) unprotect the worksheet
(2) highlight the whole worksheet, then...
FORMAT / CELLS / PROTECTION, make sure the 'Locked' check box is checked.
(3) select the appropriate range from the NAME BOX...
FORMAT / CELLS / PROTECTION, make sure the 'Locked' check box is unchecked.
(4) protect the worksheet
HTH,
Gary Brown


"dvonj" wrote:

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.