There have been many posts looking for a way to programmatically exit
Excel's edit mode. After almost a year of periodically trying I believe the
following to work on both Excel 2000 & 2003. Your mileage may vary.

The solution is based on Excel's current behavior of committing the open
edit before closing the document. Excel will also allow the integrated code
{mine is a COM addin}to cancel a close.

In a nutshell, to close an open edit, call close on the ActiveWorkbook and
set cancel to VARIANT_TRUE in an onClose handler.

It's not pretty, but it seems less fragile than sending keys {which I for
one never got to work}.

thoughts? reactions? improvements?
cheers,
dave