Determining if excel is in middle of being edited

Add-in Express™ Support Service
That's what is more important than anything else

Determining if excel is in middle of being edited
 
Phillippe Allen




Posts: 30
 Joined: 2005-11-07
In Excel, if the user clicks on an addin button, is there any way that I can determine if the user is still in the middle of editing a cell?
Posted 04 Jul, 2006 17:22:09 Top
Dmitry Kostochko


Add-in Express team


Posts: 2887
 Joined: 2004-04-05
Hi Phil,

You can try to use the Interactive property. 


function IsEditMode(const ExcelApp: TExcelApplication): boolean;
begin
  Result := False;
  try
    ExcelApp.Interactive[adxLCID] := False;
    ExcelApp.Interactive[adxLCID] := True;
  except
    Result := True;
  end;
end;


Posted 05 Jul, 2006 05:54:29 Top