Results 1 to 3 of 3
  1. #1
    karlbarlow
    Guest

    Resently used file list

    Is there a way of increasing this option passed 9 files? If so, how?

    Many thanks

  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: Resently used file list

    Hi Karl,
    To the best of my knowledge, the answer is sadly no. Even if you try setting the value using VBA rather than the Options dialog, Excel generates an error if you try and set a value greater than 9.
    Sorry!
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Resently used file list

    Just to add to what Rory said, it cannot be done in VBA either.

    Application.RecentFiles.Maximum = X, where if X greater than 9 an error message is returned.

    Andrew C

Posting Permissions

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