chart export progress bar

E

extrnh

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?
 

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

Top