can i delete a heading recent document drop down file

[exile]

how can i delete a heading from recent documents drop downfile in excel i
have deleted the
contents of page but the heading remains in dropdown list in xp its easy but
i am
new to vista and can't do can anybody help?

 

[Sheeloo]

If you have not changed the Excel version then the method should not change
between XP and VISTA.

Pl. share the Excel version and the method you followed earlier to clear the
list.

In Windows XP the MRU (Most Recently Used) list, for Excel 2007, is stored
in the Windows Registry at
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\File MRU

CAUTION: PLAYING WITH REGISTRY IS VERY DANGEROUS...

 

[jat]

in Excel, Office 2007 Vista,
press the big button on the top left corner.
select Excel Options at the bottom,
from the left side menu, select Advanced.
Select Display and set the "Show this number of REcent Documents" to 0.

doing my bit,

jat

 

[Sheeloo]

I should have mentioned this solution...

My solution is a perfect example of providing a complex solution to an easy
problem.
I thought the objective was to remove a particular file

 

[AM]

I have two buttons near the File menu, one to remove the last entry in the
Most Recent Files List and one to add to the top of the list the current
file:

Sub DelMRU()
Application.RecentFiles(1).Delete
Application.RecentFiles.Maximum = 9
End Sub

Sub AddCurFileToMRU()
Application.RecentFiles.Add Name:=ActiveWorkbook.FullName
End Sub

If I want to delete the second thru fifth file, I click the one button five
times and click the other once to put the current file back.