Suppressing Excel2007 Messages

W

Warren

Hi,

I write a simple Perl script that takes data from files, processes it and
then, using Excel Automation, dumps the data into worksheets and creates
charts with the data.

I'm playing with programatically setting 3D properties of an area series
when I get the message: "Complex formatting that is applied to the selected
chart may take a while to display. Do you want to continue using the
formatting?". The message is somewhat bogus as the time taken to the display
the formatting is negligible.

The problem is that I learnt a while ago to disable DisplayAlerts,
Interactive and ScreenUpdating, yet I still get this message. Is there a
specific way to circumvent this or should I just avoid 3D formatting?

Thanks,

Warren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel2007 Conditional Formatting Slow Performance Issue 1
Mail Merge - displaying a conditional number of decimals 5
Help with SetSourceData 1
conditional formatting, filtering then copying to another sheet 0
Calling a module from another module 5
How to inhibit non-interactive MsgBox display 4
Using While Wend with Cells.Find 1
Formatting Rich Text Content Controls in a protected document 2

Top