ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clearing the 'Recently used file list' (https://www.excelbanter.com/excel-programming/276560-re-clearing-recently-used-file-list.html)

J.E. McGimpsey

Clearing the 'Recently used file list'
 
One way:

Public Sub KillRUList()
Dim rFile As RecentFile
For Each rFile In Application.RecentFiles
rFile.Delete
Next rFile
End Sub

In article ,
flashpoint wrote:

is it possible to 'clear' the recently used file list using vb


flashpoint

Clearing the 'Recently used file list'
 
Beauty

Thank You!

Later Cal.

On Tue, 09 Sep 2003 23:24:46 -0600, "J.E. McGimpsey"
wrote:

One way:

Public Sub KillRUList()
Dim rFile As RecentFile
For Each rFile In Application.RecentFiles
rFile.Delete
Next rFile
End Sub

In article ,
flashpoint wrote:

is it possible to 'clear' the recently used file list using vb




All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com