how do I delete documents from the recent doccument box(excel)
how do I delete documents from the recent doccument box(excel)
|
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) |
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 |
how do I delete documents from the recent doccument box(excel)
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 |
how do I delete documents from the recent doccument box(excel)
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. |
All times are GMT +1. The time now is 01:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com