I have a .net addin which adds it's own command bar. I
want to catch when a cell is mid-edit and prevent my
menus from running until the edit is commited or
cancelled.
But I can't see a way to do this from the excel object
model.
Is this possible?
I have a .net addin which adds it's own command bar. I
want to catch when a cell is mid-edit and prevent my
menus from running until the edit is commited or
cancelled.
But I can't see a way to do this from the excel object
model.
Is this possible?
To catch if the user is mid-edit - I'm setting
application.interactive=false
and catching if there is com interop error; but surely
theres a better way to verify cell editing.
>-----Original Message-----
>I have a .net addin which adds it's own command bar. I
>want to catch when a cell is mid-edit and prevent my
>menus from running until the edit is commited or
>cancelled.
>
>But I can't see a way to do this from the excel object
>model.
>
>Is this possible?
>.
>
There are better ways in native code (or using P/Invoke, but YMMV).
Best regards,
Jens.
--
http://ManagedXLL.net/
Replace MSDN with my first name when replying to my email address!
"Allan" <[email protected]> wrote in message
news:[email protected]...
> To catch if the user is mid-edit - I'm setting
>
> application.interactive=false
>
> and catching if there is com interop error; but surely
> theres a better way to verify cell editing.
>
>
>
> >-----Original Message-----
> >I have a .net addin which adds it's own command bar. I
> >want to catch when a cell is mid-edit and prevent my
> >menus from running until the edit is commited or
> >cancelled.
> >
> >But I can't see a way to do this from the excel object
> >model.
> >
> >Is this possible?
> >.
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks