on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty, null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =
(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?