Click here to Skip to main content
15,879,535 members
Articles / Desktop Programming / Win32

Determining if Excel is in Edit mode with Win32 Interop

Rate me:
Please Sign up or sign in to vote.
4.56/5 (6 votes)
13 Apr 2009CPOL3 min read 46.1K   742   22   11
In this article, one can find a possible solution how to check or to be notified if the Excel Application is in Edit mode
Image 1

Introduction

Before working out any solution on our own, the web is often checked first to find whether an official solution already exists.
Regarding this issue everyone can find a couple of articles, community forum chats with lots of ideas on how to workaround the lack of Excel COM API determining if Excel application itself is in edit mode.

You can check the history here.

Background

What does edit mode really mean? When the user double clicks or starts typing over a cell, presses F2 key or uses the editor bar below further toolbars Excel starts its edit mode.

When edit mode is on, couple of menu items and functionalities alongwith do not work indicating that the application is in Edit mode (menu items get disabled).
It is the same effect if anyone writes a macro in Visual Basic for Application module and wants to start it.
Basically it is fine but if you would like to write an addin code module it is no longer true, calling some built-in functionalities from addin code causes Exceptions or your custom menu, toolbar items are still enabled and not in synch with built-in toolbar items.
There is no event or API property for you to indicate that Excel stepped in edit mode making you capable of disabling your custom stuff in time.

Even the Application.Isready property is not always working and polling a property from a different thread or by a timer is not the best approach.

For this reason, what we need is an event raised at that time when edit mode gets on or off. In addition to this, a property to give information about whether Excel is currently in edit mode and to be retrievable at any time from your code can also be useful.

Using the Code

Event provider is defined for these purposes:

C#
public class ExcelEditorModeEventPublisher : NativeWindow, IDisposable
{ 

with its event accessors:

C#
public event EventHandler EditModeOn
{
public event EventHandler EditModeOff
{

and property:

C#
public bool IsExcelInEditMode
{

The possible solution can be to observe Excel's editor window (class = "Excel6") to see whether its style has changed.
Activating the Editor window will be done by calling certain Windows 32 API calls like ShowWindow, SetWindowPos, or style changes inside of Excel SetWindowLong.
These API calls generate particular windows messages that can be detected relatively easily. To be able to do that, we need to hook on Editor window by Subclassing or Hooking it. I have chosen subclassing now as .NET provides a Native window class for safe subclassing. You can freely change this approach to using hooks by SetWindowsHookEx.

Before starting the observation, the Editor window should be found in the constructor:

C#
internal ExcelEditorModeEventPublisher
	(Microsoft.Office.Interop.Excel.Application excelApp)
{
     if (excelApp == null)
        throw new ArgumentNullException("excelApp");
     // first get the container window for each workbooks
    IntPtr workbookContainer = Win32.FindWindowEx(new IntPtr( excelApp.Hwnd ), 
                                                  IntPtr.Zero, 
                                                  "XLDESK", String.Empty);
    // check if the search was positive
    if (workbookContainer != IntPtr.Zero)
    {   // continue with finding the editor window
        IntPtr editorWindow = Win32.FindWindowEx(workbookContainer, 
                                                 IntPtr.Zero,
                                                 "EXCEL6", String.Empty);
        // subclass it if the search was successful
        if (editorWindow != IntPtr.Zero)
        {
            InitObservation(editorWindow);
            return;
        }
    }
     throw new Exception("Unfortunately, Excel editor window cannot be detected!");
}

And now we are ready to start observation via target window handle:

C#
private void InitObservation(IntPtr editorWindow)
{
    AssignHandle(editorWindow);
    CheckWindowState();
}

We are getting all messages sent to the Editor window first before it could process them throughout Window Procedure.

C#
protected override void WndProc(ref Message m)
{
    switch (m.Msg)
    {
        // win32 message if style of the targetwindow has changed by any Win32 API call
        // WS_VISIBLE flag or any other
        case (int)Win32.WM.WM_STYLECHANGED:
            CheckWindowState();
            break;
        // win32 message if position of the targetwindow has changed by 
        // SetWindowPos API call
        // SWP_SHOWWINDOW for instance
        case (int)Win32.WM.WM_WINDOWPOSCHANGED:
            CheckWindowState();
            break;
    }
    base.WndProc(ref m);
}

Therefore we are capable of notifying our listeners about activation and deactivation of the target Editor window.

C#
private void CheckWindowState()
{
    // check if the window now visible and also enabled
    if (Win32.IsWindowVisible(this.Handle) && Win32.IsWindowEnabled(this.Handle))
    {
        if (!_isEditorWindowActive)
        {   // change the state and raise event
            _isEditorWindowActive = true;
            OnRaiseSafetyEvent(_editModeOn, new object[] {this, EventArgs.Empty} );
        }
    }
    // check if the mode has changed back to non-edit mode
    else
    {
        if (_isEditorWindowActive)
        {   // change the state and raise event
            _isEditorWindowActive = false;
            OnRaiseSafetyEvent( _editModeOff, new object[]{this, EventArgs.Empty} );
        }
    }
}

History

  • Viktor Hamori 13/04/2009 - 2. Version added protection for Excel message handler if the client subscriber fails (throws exception) for any reason

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Hungary Hungary
Office (Word, Excel) specialist
C#, COM, VC++, VB6
MFC, ATL,

Comments and Discussions

 
BugExcel 2016 / multiple workbooks on same Excel instance Pin
TunsianSimpson6-Aug-18 2:41
TunsianSimpson6-Aug-18 2:41 
NewsLatest version of Excel throw "Unfortunately, Excel editor window cannot be detected" Pin
Member 1323303725-Oct-17 17:58
Member 1323303725-Oct-17 17:58 
QuestionGreat article, but how? Pin
otterpdp25-Jun-12 9:10
otterpdp25-Jun-12 9:10 
AnswerRe: Great article, but how? Pin
Viktor Hamori28-Aug-13 10:33
Viktor Hamori28-Aug-13 10:33 
Generalanother edit mode case Pin
who_i25025-Apr-11 20:38
who_i25025-Apr-11 20:38 
GeneralRe: another edit mode case Pin
Viktor Hamori26-Apr-11 3:38
Viktor Hamori26-Apr-11 3:38 
QuestionEdit Directly in Cell Pin
engstrocity9-Apr-11 5:25
engstrocity9-Apr-11 5:25 
AnswerRe: Edit Directly in Cell Pin
Viktor Hamori26-Apr-11 3:35
Viktor Hamori26-Apr-11 3:35 
GeneralRe: Edit Directly in Cell Pin
spcghst440@hotmail.com22-Oct-12 3:19
spcghst440@hotmail.com22-Oct-12 3:19 
GeneralRe: Edit Directly in Cell Pin
spcghst440@hotmail.com22-Oct-12 4:14
spcghst440@hotmail.com22-Oct-12 4:14 
GeneralRe: Edit Directly in Cell Pin
spcghst440@hotmail.com22-Oct-12 5:34
spcghst440@hotmail.com22-Oct-12 5:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.