+ Reply to Thread
Results 1 to 3 of 3

Prevent file from showing up in recent documents list

  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    Toledo, OH
    MS-Off Ver
    Microsoft Office 2010
    Posts
    85

    Prevent file from showing up in recent documents list

    Is there a line of code I can add to the Workbook Before Close event to prevent the file from showing up in the Recent Documents list? You know, the one where you right-click on the Excel icon and it displays the files you've opened most recently? It would need to work for multiple users on multiple computers, not just mine. And I only want it to happen for this particular file, not all Excel files.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Prevent file from showing up in recent documents list

    Please Login or Register  to view this content.
    This will target the first file in the list, which should be the active document.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Prevent file from showing up in recent documents list

    And if you it wasn't the most recent opened file, you could use a short loop:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Personal.xlsb showing in My Recent Documents
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2014, 11:00 PM
  2. [SOLVED] File saved w macro not showing up in Recent Documents
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2013, 09:07 PM
  3. Recent Workbook File List
    By tleaton in forum Excel General
    Replies: 1
    Last Post: 05-11-2011, 12:15 PM
  4. Replies: 2
    Last Post: 03-23-2009, 10:16 AM
  5. Replies: 0
    Last Post: 11-08-2007, 03:39 AM
  6. Recent File List Problem
    By GB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2006, 05:30 PM
  7. Most recent file list
    By Mikerosoft in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2005, 11:25 AM
  8. [SOLVED] Excel Documents Don't Appear in My Recent Documents
    By Addi in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1