How do I clear the recent document list in Excel 2003 viewer?

D

Dana DeLouis

How do I clear the recent document list in Excel 2003?

One way...

Sub ClearMRU()
Dim Remember As Long

With Application
Remember = .RecentFiles.Maximum
.RecentFiles.Maximum = 0
.RecentFiles.Maximum = Remember
End With
End Sub
 
Top