Removing history of files from the File menu

[Richard Mahan]

I woulk like to know how to delete the history of recent files form the
file menu.

 

[Roger Govier]

Hi Richard

Under Tools>Options>General delete the value in Recently Used Files
List.
Don't use the spinner, as this will not allow you to go below 1, and it
will not allow you to set it to zero, so just press delete in the box.

To do it programmatically, something like the following

Sub HideRecentFiles()
With Application
.RecentFiles.Maximum = 0
End With
End Sub

Obviously you would want the reverse to Show the List, where you set the
value to something greater than 0

 

[Richard Mahan]

Thankyou so much, that works.

Hi Richard

Under Tools>Options>General delete the value in Recently Used Files List.
Don't use the spinner, as this will not allow you to go below 1, and it
will not allow you to set it to zero, so just press delete in the box.

To do it programmatically, something like the following

Sub HideRecentFiles()
With Application
.RecentFiles.Maximum = 0
End With
End Sub

Obviously you would want the reverse to Show the List, where you set the
value to something greater than 0