Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2004
    Location
    Albany, New York, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet Navigation (Excel 2003)

    Hello All,

    I did something that is causing a lot of frustration... I work within workbooks with many worksheets in them and use CTRL+Page up or Page down to navigate from sheet to sheet. For what ever reason, it stopped working. Using the buttons alone work, so I know it's not the keyboard and I've tried turning on and off scroll lock.

    Is there a setting to turn this on or off? Woody's loungers have never let me down, so thank you for all your help!

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

    Re: Worksheet Navigation (Excel 2003)

    Did you reassign the keyboard shortcuts? Try this first:
    - Press Alt+F11 or select Tools | Macro | Visual Basic Editor.
    - Press Ctrl+G or select View | Immediate Window.
    - Type
    <code>
    Application.OnKey "^{PGUP}"
    </code>
    - Press Enter
    - Type
    <code>
    Application.OnKey "^{PGDN}"
    </code>
    - Press Enter
    - Switch back to Excel to check whether Ctrl+Page Up and Ctrl+Page Down work correctly again. If not, check out Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Worksheet Navigation (Excel 2003)

    Do you have protected worksheets in the workbook?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Lounger
    Join Date
    Mar 2004
    Location
    Albany, New York, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet Navigation (Excel 2003)

    So I tried the VBA fix without success. I checked with a coworked who suggested the obvious of rebooting..which worked.

    Now I'm left curious to the cause, but thankful it's fixed. thank you all for your suggestions!

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

    Re: Worksheet Navigation (Excel 2003)

    Applications sometimes become confused, and in most cases you'll never know the real cause.
    If quitting and restarting the application doesn't help, restarting your PC often does.

Posting Permissions

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