You have to use vba code to do that.
The code shown in the link below (from a post of mine last year)...
removes non-existent files from the Recent Files List and
adds the names of any open & saved workbooks to the list.
http://tinyurl.com/3y6hqy
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"susan carroll"
wrote in message
How do I delete items out of my "recent documents" list?