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
--
Regards

Roger Govier


"Richard Mahan" <dmachen35@comcast.net> wrote in message
news:jZGdnU_UQ_RWvY3ZRVn-tA@comcast.com...
> I woulk like to know how to delete the history of recent files form
> the file menu.
>

[Richard Mahan]

Thankyou so much, that works.

"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:ezEodf3QGHA.5900@tk2msftngp13.phx.gbl...
> 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
> --
> Regards
>
> Roger Govier
>
>
> "Richard Mahan" <dmachen35@comcast.net> wrote in message
> news:jZGdnU_UQ_RWvY3ZRVn-tA@comcast.com...
>> I woulk like to know how to delete the history of recent files form
>> the file menu.
>>
>
>