I want to be able to press the tab button but only go to the unprotected cells.
Is there a way to bypass cells using tab???
Thanks
I want to be able to press the tab button but only go to the unprotected cells.
Is there a way to bypass cells using tab???
Thanks
Last edited by JK1234; 06-08-2010 at 11:46 AM. Reason: Solved
When you protect your sheet, be sure to set the options you want. One of the options is [x] Select Locked Cells... uncheck that.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Even if you have not unchecked "Select Locked Cells", once you've protected your worksheet, the Tab moves you between Unlocked cells only. If you're tabbing and you're moving to unlocked cells, then either your worksheet isn't protected or you have more unlocked cells than you thought.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks