ExcelBanter - How can I turn off the OLE warning when merging cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I turn off the OLE warning when merging cells? (https://www.excelbanter.com/excel-programming/392801-how-can-i-turn-off-ole-warning-when-merging-cells.html)

NewarkGoss

How can I turn off the OLE warning when merging cells?

I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
up a warning dialog. How do I suppress this.

steve_doc

How can I turn off the OLE warning when merging cells?

Have you tried Application.Display alerts = False ?

"NewarkGoss" wrote:

I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
up a warning dialog. How do I suppress this.

NewarkGoss

How can I turn off the OLE warning when merging cells?

Thanks Steve. That worked as <oleobject.DisplayAlerts = False (no space)

"steve_doc" wrote:

Have you tried Application.Display alerts = False ?

"NewarkGoss" wrote:

I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
up a warning dialog. How do I suppress this.

All times are GMT +1. The time now is 05:39 AM.