Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Columbia, South Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab order (Excel 2000/2002)

    Is there any method to control the tab/enter order in Excel to go to the next non-locked cell, or alternately to specify where the cursor should go after the user enters a value? I know an option exists to control whether Enter takes you down or across (or other options), but I want to have the cursor go to specific unlocked cells on a protected worksheet that are neither down nor across (think of Excel as a form here, with only specific cells used for input).

    Thanks!
    Chip

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order (Excel 2000/2002)

    Hi Chip:

    Try this:

    In order to obtain that effect

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Location
    Columbia, South Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order (Excel 2000/2002)

    Exactly what I was looking for. Works like a charm. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •