PDA

View Full Version : Tabbing Issues



spaz9876
04-10-2007, 11:15 AM
I protected a worksheet and now when you press tab, it jumps from row 1 to 2977 to 5501.
How can I fix it so that when you press tab, it goes from left to right across the row like normal?

lucas
04-10-2007, 11:48 AM
It should tab to the unprotected cells....

spaz9876
04-10-2007, 12:03 PM
Then maybe I have the protection on wrong. I set Range1 to column K through BT with a password and then Range2 is Column A through J (without a password). Column A-J are the ones that are allowed to be edited but when you protect the whole worksheet and then use the tab, it tabs to only 4 cells out of over 5000!

lucas
04-10-2007, 12:13 PM
see attached

you have to unlock them first