Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Jumping Cells (2002)

    I have set up a spreadsheet with a number of lookups, eg cell A1 value puts values from a lookup table into cells B1 & C1 (these are protected). The next cell that requires any manual input is in D1. Is there a way to be able to jump over B1 & C1 after entering a value into A1?

    <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22> Dean

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jumping Cells (2002)

    1. Unprotect the worksheet.
    2. Select Tools | Protection | Protect Sheet...
    3. In the dialog, clear the Select Locked Cells check box. (This is a new feature in XL2002)
    4. Click OK.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jumping Cells (2002)

    Hitting the TAB kay will make Excel jump to the next unprotected cell in any version (as long as the worksheet is protected)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Jumping Cells (2002)

    Dean:

    Other way...

    1) Unlock the cells to which you want to jump
    2) In properties sheet : EnableSelecctions=xlUnlockedCells
    3) At end, Protect Sheet...

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jumping Cells (2002)

    Servando,

    The setting you recommend works fine, but it is not "sticky", that is, it is not stored in the workbook. So you would have to create a Workbook_Open macro in the ThisWorkbook module to restore this setting each time the workbook is opened.

Posting Permissions

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