Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could use sheet protection to get the behaviour you described.
Select the cells that you want the cursor to move through, then go to formatcellsprotection and uncheck the "locked" checkbox. Then go to ToolsProtection and uncheck the "Select locked cells" checkbox (make sure the "Select unlocked cells" and "Protect worksheet and contents of loicked cells" boxes are checked.). Tab will move exactly how you described, but getting enter to do it enter requires another step assuming your cursor is set to move down on Enter: use this line in the sheet activate event: Application.MoveAfterReturnDirection = xlToRight on deactivate: Application.MoveAfterReturnDirection = xlDown Or if you would like the cursor to always go to the right on enter, go to ToolsOptionsEdit and choose "Right" from the "Move selection after Enter" item. Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can someone help me with code for tab/enter stops? | Excel Programming | |||
can someone make code for tab/enter stops for me please? | Excel Discussion (Misc queries) | |||
VB Code stops working | Excel Programming | |||
Let's try again: VBA Code stops randomly | Excel Programming | |||
Code stops when high lighting (Chips code) | Excel Programming |