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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution: How to programmaticaly leave "edit mode"
David,
I'm confused. How do you call the procedure while you are editing a cell? Can you give an example of when you would run this and how it would work? Doug "David Owens" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution: How to programmaticaly leave "edit mode"
He is having code manipulate Excel. The problem is that if the user is in
edit mode when the code runs, the code fails. There is no way to chekc if the user is in edit mode, so this way, the code can force the user out of edit mode so the code can then do its very important work. -- Regards, Tom Ogilvy "Doug Glancy" wrote in message ... David, I'm confused. How do you call the procedure while you are editing a cell? Can you give an example of when you would run this and how it would work? Doug "David Owens" wrote in message ... 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 |
Reply |
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) |