View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
AM[_2_] AM[_2_] is offline
external usenet poster
 
Posts: 1
Default can i delete a heading recent document drop down file

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.


"exile" wrote in message
...
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?