Excel: Removing the Most Recently Opened Files from File Menu

ID: Q75547

The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0
  • Microsoft Excel for OS/2, version 3.0

SUMMARY

In Microsoft Excel, the four most recently opened documents are listed at the bottom of the File menu. However, you may not want these to display. To keep the file list from appearing in the File menu, create and run the following macro: 


   A1: =DELETE.COMMAND(GET.BAR(),1,"file list")
   A2  =RETURN()
You can remove any menu command from a Microsoft Excel menu with the DELETE.COMMAND function, including the recently opened files list.

To remove the list of recently opened files from the Window menu, substitute "window list" for "file list" in the above example of the DELETE.COMMAND function.


REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 104-105

"Microsoft Excel User's Guide 2," version 4.0, page 285

"Microsoft Excel Function Reference," version 3.0, pages 51-52

"Microsoft Excel User's Guide," version 3.0, page 645

Additional query words: 3.0 last recent mru most recently used files list

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: July 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.

Send feedback to MSDN.Look here for MSDN Online resources.