Edit

RecentFiles.Maximum property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.