Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Workbook list in Window menu (2000/SP3)

    I note that the list of open workbooks displayed in the Window pull-down menu is arranged with the most recently opened at the top (1), the second most recently opened next, etc.
    I have been unable to find documentation verifying that this is always so, and cannot be changed through an option setting.
    Can anyone offer comment.
    Although I am working in Office 2K, I need knowledge on this issue for all versions of Excel (98 and later).
    Regards
    Don

  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: Workbook list in Window menu (2000/SP3)

    Hi,
    It has always been that way as I recall and there is no option to change it. May I ask why the order is important?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Workbook list in Window menu (2000/SP3)

    Rory
    Thanks for the speedy response.
    I'm using an Auto_Open macro, and if the file in question was minimized when last saved; upon opening it is not the active window. Since I cannot guarantee the filename on opening, this piece of information makes it unnecessary to generate code to try and sort out the situation.
    Regards
    Don

  4. #4
    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: Workbook list in Window menu (2000/SP3)

    If you mean you are trying to refer to the workbook containing the Auto_Open macro, you can just use ThisWorkbook instead of ActiveWorkbook.
    Hope that helps?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Workbook list in Window menu (2000/SP3)

    Thanks again Rory
    You saw directly into the problem.
    Regards
    Don

Posting Permissions

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