How do I detect cell mode?

[Andrej.Gaevskij]

I am looking for any advice as to how to detect cell mode. How to I
detect that cell in edit mode?

 

[Guest]

the file=>Open option in the menu will be disabled.

 

[Andrej.Gaevskij]

the file=>Open option in the menu will be disabled.

But I need detect cell mode in my c# code...

 

[Guest]

You should be able to check the status of the menu item in your c# code.

 

[Guest]

Not something I have used, but you can check and see if checking the ready
property of the application object will indicate this:

Sub UseReady()

If Application.Ready = True Then
MsgBox "Application is ready."
Else
MsgBox "Application is not ready."
End If

End Sub

However in one thread someone said it returned true regardless of the state
of edit mode. The Ready property is in xl2002 and later. \

this is vba code to check the state of the Open menu item if you want to try
and to it in C#.

Dim C As Office.CommandBarControl
Set C = Application.CommandBars.FindControl(ID:=23) ' Open
button
If C.Enabled = True Then
Debug.Print Now, "Not Edit Mode"
Else
Debug.Print Now, "Edit Mode"
End If

 

[Andrej.Gaevskij]

Not something I have used, but you can check and see if checking the ready
property of the application object will indicate this:

Sub UseReady()

If Application.Ready = True Then
MsgBox "Application is ready."
Else
MsgBox "Application is not ready."
End If

End Sub

However in one thread someone said it returned true regardless of the state
of edit mode. The Ready property is in xl2002 and later. \

this is vba code to check the state of the Open menu item if you want to try
and to it in C#.

Dim C As Office.CommandBarControl
Set C = Application.CommandBars.FindControl(ID:=23) ' Open
button
If C.Enabled = True Then
Debug.Print Now, "Not Edit Mode"
Else
Debug.Print Now, "Edit Mode"
End If

Thanks, Tom! Great solution of my problem!