IF WE PRESS RIGHT ARROW KEY, WE WILL MOVE TO NEXT CELL, RIGHT? my question is if i press right arrow key while being in "A" column, we should go to "E" column. I NEED "A" COLUMN to type my data's, and B,C,D columns i dont type any data. so I want jump Directly to "E" Column While pressing right arrow key. i dont want hidden B,C,D columns Because some lookup is there,
is this possible
Last edited by vengatvj; 09-21-2013 at 08:17 PM.
lock the cells in Columns B,C,D making sure the select locked cells checkbox is not checked?
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
1. select the cells/ranges you want to be able to enter data in.
2. go into formatting/protection and unckeck "Locked"
3. then Right-click the worksheet tab and select "protect sheet"
4. uncheck "select locked cells"
5. check/uncheck any other options you want to allow/not allow
6. click OK
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ITS WORKING, but some time i need to edit some data in locked cells. just i want skipp while pressing right arrow key, all cells in lookup, if N/A in a cell i need to type manually my data. that time again i need to sheet, uncheck protected .. just i move cell directly to where i want to move.. other wise i need to see all cell, only i will type when my lookup gives N/A...
I would fix what is causing the error, instead of trying to enter data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks