The way you use Application.DataEntryMode is to first make sure all the
input cells have the Locked format removed. Then you have to select the
input range (the range you want the user to be able to roam about), and then
you set the mode.

If you set it to True users can press Esc to exit DEM. If you set it to
xlStrict they cannot however you must give them (or yourself) a way to exit
DEM (Application.DataEntryMode=False).

This is very old technology. The EnableSelection and ScrollArea methods
introduced in Excel 97 were supposed to supercede it. But without DEM there
is no way to disable Excel Options or the Recent Documents list (as far as I
know). MS did not do developers a favor.

--
Jim
"MK" wrote in message
...
However, data cannot be input.
How should I do to be able to input data, and to disables it?

"MK" wrote:

Thank you very much.

I was able to solve it.

"Jim Rech" wrote:

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.
|