ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unable to set DisplayAlerts property (https://www.excelbanter.com/excel-programming/365241-unable-set-displayalerts-property.html)

[email protected]

Unable to set DisplayAlerts property
 
Hi,
I am writing an Excel automation program using C++ and MFC. I am
setting several properties for the Application class and most are
working. However, the DisplayAlerts property is giving me an error.

If I step through in the debugger, it works fine. But when I run it, I
get the message "Unable to set the Display Alerts property of the
Application class".

Any ideas???

Here is a code snipet:

//Then get the worksheet's application.
app = wb.GetApplication();
app.SetDisplayFormulaBar(FALSE); // Works Fine
app.SetDisplayAlerts(FALSE); //Gives error message

Thanks so much!!
Jennifer



All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com