none
How do I know if Excel is in edit mode? RRS feed

Answers

All replies

  • Hello,

    Please read How to check programmatically if the user is editing an Excel cell.


    Regards from Belarus (GMT + 2),

    Andrei Smolin
    Add-in Express Team Leader
    Friday, July 8, 2011 8:59 AM
  •        Excel._Application ExcelApp;
    public bool IsEditing()
            {
                if (ExcelApp.Interactive == false)
                    return false;
                try
                {
                    ExcelApp.Interactive = false;
                    ExcelApp.Interactive = true;
                }
                catch
                {
                    return true;
                }
                return false;
            }
    write the above function to ur program and give a call to this function. if it is returning 'true' then the excel is in editmode and if 'false' the excel is out of editmode..

    • Proposed as answer by MehulSant Wednesday, August 3, 2011 8:26 AM
    Wednesday, August 3, 2011 8:20 AM