Tools - OPtions - General

No such thing in Excel 2007.

While you can set the number of files to display under Excel Options in
Excel 2007, when you set it to zero, that wipes out the user's MRU list. So
if this setting is reset later there are no files there. Users will not
thank you for this.

This is no way to block this list from appearing short of zeroing it out.
You can disable the list by Application.DataEntryMode=True (or xlStrict).
This also disables Excel Options and is the only way to do that, as far as I
know.

--
Jim
"Barb Reinhardt" wrote in message
...
| Tools - OPtions - General
| Deselect recently used file list
|
|
| "MK" wrote:
|
| I want to do "Recent Documents" and "Excel Options" on right side of
| Officemenu to non-display.
| Is there a method?
| Please teach me.
|