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.

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.

I will try this. I am not a novice to Excel, but I have never worked with
Macros. This will be my first crack at it, so I may not do it right away.
Thanks for the suggestion, I will let you know.

"Bernie Deitrick" wrote:

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.

Alfie

Before you get too far.............

Bernie's code removes entries from the regular File MRU list, not the from the
Task Pane Recently used Templates.

I can't help you with the Task Pane problem.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 10:25:00 -0800, Alfie
wrote:

I will try this. I am not a novice to Excel, but I have never worked with
Macros. This will be my first crack at it, so I may not do it right away.
Thanks for the suggestion, I will let you know.

"Bernie Deitrick" wrote:

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.

Ok, found my answer:

You have to go to
"HKEY_CURRENT_USER†’Software†’Microsoft†’Office †’11.0†’Excel†’Recent Templates" in
Windows Registry, and clear unwanted strings.



"Gord Dibben" wrote:

Alfie

Before you get too far.............

Bernie's code removes entries from the regular File MRU list, not the from the
Task Pane Recently used Templates.

I can't help you with the Task Pane problem.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 10:25:00 -0800, Alfie
wrote:

I will try this. I am not a novice to Excel, but I have never worked with
Macros. This will be my first crack at it, so I may not do it right away.
Thanks for the suggestion, I will let you know.

"Bernie Deitrick" wrote:

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.

Alfie

Thanks for posting this.

Now we all know.


Gord

On Fri, 15 Dec 2006 13:19:01 -0800, Alfie
wrote:

Ok, found my answer:

You have to go to
"HKEY_CURRENT_USER?Software?Microsoft?Office?11.0 ?Excel?Recent Templates" in
Windows Registry, and clear unwanted strings.



"Gord Dibben" wrote:

Alfie

Before you get too far.............

Bernie's code removes entries from the regular File MRU list, not the from the
Task Pane Recently used Templates.

I can't help you with the Task Pane problem.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 10:25:00 -0800, Alfie
wrote:

I will try this. I am not a novice to Excel, but I have never worked with
Macros. This will be my first crack at it, so I may not do it right away.
Thanks for the suggestion, I will let you know.

"Bernie Deitrick" wrote:

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.






Gord Dibben MS Excel MVP