Search code examples
c#excelexcel-dna

Excel Screen Updating to False Using ExcelDna

I am trying to set Excel Screen Updating to false using ExcelDna. I do not want to use COM. Using its XlCall is preferred. Can someone help?

Solution

  • You can use XlCall.xlcEcho to enable/disable screen updating. E.g.:

    // Disable screen updating
XlCall.Excel(XlCall.xlcEcho, false);

// Enable screen updating
XlCall.Excel(XlCall.xlcEcho, true);