how to find out whether the active cell is in edit mode or not?

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?

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?

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?

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?

I don't use .Net/Interop but I do not see any Excel code running <<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the .Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
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?