View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis
 
Posts: n/a
Default How do I clear the recent document list in Excel 2003 viewer?

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

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"vnavna" wrote in message
...