View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Recently Used Templates list in Task Pane

Alfie,

Try a macro like this:

Sub RemoveFilesFromRecentList()
Dim i As Integer
For i = Application.RecentFiles.Count To 1 Step -1
If MsgBox("Delete this file from recent files? " & Chr(10) & _
Application.RecentFiles.Item(i).Name, vbYesNo) = vbYes Then
Application.RecentFiles.Item(i).Delete
End If
Next i
End Sub

HTH,
Bernie
MS Excel MVP


"Alfie" wrote in message
...
Hi, I'm wondering if anyone has figured out a way to clear off an item or
even the entire list of Recently Used Templates in the Task Pane?
Specifically asking about Excel 2003, but applies to all Office 2003 products
installed on my workstation.