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?
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?
It should tab to the unprotected cells....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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!
see attached
you have to unlock them first
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln