Hi Gord,

Your macro below works fine ... but ... I believe that Excel 2007 only
allows macros to be created in an open workbook. Is there any way that it
can be set up like Word 2007, so that the macro is available whenever Excel
2007 is launched (i.e. available to any workbook that is subsequently opened)?

Many thanks,

Geoff

"Gord Dibben" wrote:

Clear it then reset it.

Sub toggle_MRU()
With Application
.RecentFiles.Maximum = 0
End With
With Application
.RecentFiles.Maximum = 3
End With
End Sub


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 04:54:02 -0700, joelle1110
wrote:

I just need to know how to clear what shows in my recent documents because
all the files listed have been moved to another location and are no longer
accurate.