Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Unable to select names (Excel97 sr2)

    For some reason, I cannot select a named range from the name box.
    Same is true when trying to select function to use in a cell (you know...when you enter the equal sign and then select a function from the drop down). The function drop down appears correctly when I enter an equals sign, but when I select a function nothing happens.
    Same true with named ranges.
    I am still able to use the goto and the insert function operability, just blinking annoying not being able to use the selected lists.

    Any ideas?

    Alan
    Cheshire
    UK

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

    Re: Unable to select names (Excel97 sr2)

    Is this on any workbook or on one particular one?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Unable to select names (Excel97 sr2)

    It happens on any workbook.
    Opened Excel to blank workbook and same is true, cannot select a function to insert but the Insert>Function works OK.

    Is there a wizard check in VBA that I can run..anyone?

    TIA
    Alan
    Cheshire
    UK

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Unable to select names (Excel97 sr2)

    Check out the starpost by Jan Systematic Approach to Behavioral Problems in XL

    Steve

Posting Permissions

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