how do I delete documents from the recent doccument box(excel)

You can't delete individual documents, but if you want to clear the list,
use Tools/ Options/ General, and set Recently used file list to zero
entries. You can then set it back to a non-zero number to let it start a
new list.
--
David Biddulph

"john" wrote in message
...
how do I delete documents from the recent doccument box(excel)

This works ok for me in xl2003--but I've never tested it in xl2007.

Option Explicit
Sub testme()

Dim iCtr As Long
Dim MRUMax As Long
Dim TestStr As String

With Application.RecentFiles
MRUMax = .Maximum
For iCtr = .Count To 1 Step -1
TestStr = ""
On Error Resume Next
TestStr = Dir(.Item(iCtr).Path)
On Error GoTo 0
If TestStr = "" Then
.Item(iCtr).Delete
End If
Next iCtr
.Maximum = MRUMax
End With

End Sub


If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

john wrote:

how do I delete documents from the recent doccument box(excel)

--

Dave Peterson

Ps. That code deletes names of files that don't exist.

john wrote:

how do I delete documents from the recent doccument box(excel)

--

Dave Peterson

Further to David's suggestion.

Sub toggle_MRU()
With Application
.RecentFiles.Maximum = 1 'leaves current workbook on list
End With
With Application
.RecentFiles.Maximum = 5
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 16 Dec 2009 05:52:07 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

You can't delete individual documents, but if you want to clear the list,
use Tools/ Options/ General, and set Recently used file list to zero
entries. You can then set it back to a non-zero number to let it start a
new list.