| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution: How to programmaticaly leave "edit mode"
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| How do I get "file" tab to click on, it starts with "edit" | Excel Discussion (Misc queries) | |||
Threaded Mode
