CODEWITHSUNDEEP
c#exceloffice-interopexcel-interop
B. Clay Shannon-B. Crow Raven
B. Clay Shannon-B. Crow Raven

Reputation: 10247

Is there a reason to toggle MSExcel.Excel.ApplicationClass.DisplayAlerts?

In a project I've taken over, I found this code:

private MSExcel.Excel.ApplicationClass _xlApp;
. . .
_xlApp.DisplayAlerts = false;
_xlApp.DisplayAlerts = true;

Since I don't know why MSExcel.Excel.ApplicationClass.DisplayAlerts would be toggled from false to true with no code in between, I will leave it like it is for now anyway, but why would this toggle be beneficial or necessary?

Upvotes: 1

Views: 70

Answers (1)

gadaju
gadaju

Reputation: 416

One case: If you use a macro/VBA to delete sheets from the workbook and don't want the msgbox saying "Are you want to Delete this worksheet?" to pop up, then you

_xlApp.DisplayAlerts = false;
ActiveWorkBook.WorkSheets("Sheet2").delete
_xlApp.DisplayAlerts = true;

and the code will delete Sheet2 without prompting the user to click ok, and more importantly for me, the routine will run to completion while you're getting coffee.

Upvotes: 1

Related Questions