Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 360
Default can someone help me with code for tab/enter stops?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can someone help me with code for tab/enter stops? ilia Excel Programming 0 November 21st 07 06:07 PM
can someone make code for tab/enter stops for me please? officegirl77 Excel Discussion (Misc queries) 0 November 21st 07 04:43 PM
VB Code stops working Michelle K Excel Programming 17 August 17th 07 05:58 PM
Let's try again: VBA Code stops randomly BAC Excel Programming 23 March 20th 07 06:44 PM
Code stops when high lighting (Chips code) ste mac Excel Programming 6 May 2nd 06 01:39 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"