Recently Used Templates list in Task Pane
 

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.

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.

Recently Used Templates list in Task Pane
 

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.

Recently Used Templates list in Task Pane
 

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.

Recently Used Templates list in Task Pane
 

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.

Recently Used Templates list in Task Pane
 

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