Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing Excel2007 Messages
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing dialogs | Excel Programming | |||
Suppressing Input Box | Excel Programming | |||
Suppressing a message box | Excel Programming | |||
Hi all!! Suppressing the "Do you want to save changes" | Excel Worksheet Functions | |||
Suppressing messages | Excel Programming |