I am using VSTO to develop a C# addin for Excel.

I have several commands in the ribbon that I do not want to be available if
the user has double clicked on a cell and is entering text.

How can I disable my buttons when the user is in either edit or enter mode?
(in the same way the ms alignment, styles etc buttons are disabled)

Also, is there any property I can use to discover the mode excel is in? I
have tried the application.ready property but it isn't what I'm looking for.

Alice,
Whilst such functionality is not available from a VBA point of view, I have
seen advise from MS to check Application.Ready, although it seems it may not
function correctly.
This always returns True in VBA as it cannot run in Edit mode, so I can't it
test it now.

Otherwise, you can test if the menu item File>Open is enabled.

NickHK

"Alice Graham" <(E-Mail Removed)> wrote in message
news:80F734FE-EBEC-438A-8564-(E-Mail Removed)...
> I am using VSTO to develop a C# addin for Excel.
>
> I have several commands in the ribbon that I do not want to be available
if
> the user has double clicked on a cell and is entering text.
>
> How can I disable my buttons when the user is in either edit or enter
mode?
> (in the same way the ms alignment, styles etc buttons are disabled)
>
> Also, is there any property I can use to discover the mode excel is in? I
> have tried the application.ready property but it isn't what I'm looking
for.
>

Testing the File>Open status sounds good to me.
Thanks for the suggestion

"NickHK" wrote:

> Alice,
> Whilst such functionality is not available from a VBA point of view, I have
> seen advise from MS to check Application.Ready, although it seems it may not
> function correctly.
> This always returns True in VBA as it cannot run in Edit mode, so I can't it
> test it now.
>
> Otherwise, you can test if the menu item File>Open is enabled.
>
> NickHK
>
> "Alice Graham" <(E-Mail Removed)> wrote in message
> news:80F734FE-EBEC-438A-8564-(E-Mail Removed)...
> > I am using VSTO to develop a C# addin for Excel.
> >
> > I have several commands in the ribbon that I do not want to be available
> if
> > the user has double clicked on a cell and is entering text.
> >
> > How can I disable my buttons when the user is in either edit or enter
> mode?
> > (in the same way the ms alignment, styles etc buttons are disabled)
> >
> > Also, is there any property I can use to discover the mode excel is in? I
> > have tried the application.ready property but it isn't what I'm looking
> for.
> >
>
>
>