Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA editor - Project explorer (Win XP SP2 - O2003 pro UK)

    Hi,

    In Excel - in my VBE - 'project explorer' - I have somehow managed to get the sort order changed.

    Default:
    1. Worksheets
    2. Modules
    3. Class modules

    They are now all mixed and only sorted alphabetically.

    Does anyone know where I can reset this??

    THX
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    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: VBA editor - Project explorer (Win XP SP2 - O2003 pro UK)

    Click the Folder icon at the top of the project explorer - it toggles Folders on and off.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: VBA editor - Project explorer (Win XP SP2 - O2003 pro UK)

    As far as I know the way the project explorer is displayed can't be changed. Could you post a screenshot? (Max. 640x480 pixels, max 100KB; .png, .gif or .jpg format works best)

    Added later: oops, see Rory's reply.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA editor - Project explorer (Win XP SP2 - O2003 pro UK)

    Thanks Rory,

    So easy, simple and obvious once you know... <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    This happened just after a quick double click, where I thought I was closing a project. Next time I entered it looked like that. My problem was that I had no clue of what I had done... <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    - guess it was the arch type of an 'error 40' // ;o)
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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