ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   chart export progress bar (https://www.excelbanter.com/excel-discussion-misc-queries/156635-chart-export-progress-bar.html)

extrnh

chart export progress bar
 
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?



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com