RecentFiles.Maximum Property (Excel)
Returns or sets the maximum number of files in the list of recently used files. Can be a value from 0 (zero) through 50. Read/write Long.
Syntax
expression .Maximum
expression A variable that represents a RecentFiles object.
Example
This example sets the maximum number of files in the list of recently used files to 6.
Application.RecentFiles.Maximum = 6