is there a way to prevent the progress bar from displaying when
exporting charts through vba? i have a macro that is acitvated by a
vb6 exe which exports charts as gif files. the vb6 program is
launched by a timer and the intent is for the process to run in the
background, excel is not visible. everything works ok except there is
a progress bar that pops up each time a chart is exported. setting
the application.diplayalerts and application.screenupdating attributes
to true does not stop the progress bar from being displayed. is there
another switch to prevent this?