Recently Used File List Disabled (158159)

WORKAROUND

To make the most recently used file list available on the File menu, do the following:

1. On the Tools menu, click Options.
2. Click the General tab.
3. Select the Recently Used File List option.
4. Click OK.

This is a temporary solution, because the Recently Used File List is unavailable when you restart Microsoft Excel. This setting can be automatically turned on through a Visual Basic for Applications macro.

Microsoft provides examples of Visual Basic for Applications procedures for illustration only, without warranty either expressed or implied, including, but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures in this article are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. While Microsoft support professionals can help explain the functionality of a particular macro, they will not modify these examples to provide added functionality, nor will they help you construct macros to meet your specific needs. If you have limited programming experience, you may want to consult one of the Microsoft Solution Providers. Solution Providers offer a wide range of fee-based services, including creating custom macros. For more information about Microsoft Solution Providers, call Microsoft Customer Information Service at (800) 426-9400.

The following macro will turn on the Recently Used File List.

   Sub Auto_Open()
       Application.DisplayRecentFiles = True
   End Sub
				

Enter the macro code on a module sheet. For the macro to open every time you start Microsoft Excel, put this macro in the Personal.xls file which is saved in the "C:\MSOffice\Excel\XLStart" folder. The location of the XLStart folder may be different depending on what you chose during setup.

NOTE: If you open a workbook from the Microsoft Excel Recent File List, Windows File Manager, Windows Explorer, an electronic mail message, or from a Web browser (such as the Microsoft Internet Explorer), the workbook is not checked automatically for macros that might contain viruses. If you open workbooks in any of these ways, or if you decide to open a workbook with macros, you can check these workbooks as follows and remove the Laroux virus before you save the workbooks or pass the virus on to other workbooks.

To clear the virus from open workbooks:

1. On the Tools menu, click Virus Search.
2. Click Yes when you are prompted to search for the virus.
3. Select Currently Open Workbooks and then click OK.
4. If the Virus Search add-in reports that the Laroux virus was found and removed from a workbook, it prompts you to save the workbook. Click Yes, so that the clean copy of the workbook replaces the infected copy on your disk.