LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change font when sheet is protected vivisss Excel Discussion (Misc queries) 1 February 7th 05 07:54 PM
"change order form" Dee Excel Discussion (Misc queries) 0 February 2nd 05 11:05 PM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM
How do I change the order of the legend entries? Kerrin Charts and Charting in Excel 1 January 10th 05 10:03 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"