ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disabling chart export progress bar (https://www.excelbanter.com/excel-programming/403936-disabling-chart-export-progress-bar.html)

extrnh

disabling chart export progress bar
 
i have a macro that exports charts as gif files using the following
code:

Charts(i).Export Filename:=strWebPath & "images\" &
strChartName & ".gif", FilterName:="gif"

when each chart is exported, a progress bar is displayed. i would
like to disable the display of the progress bar form, but
Application.DisplayAlerts = False and Application.ScreenUpdating =
False do not work.

any ideas on how to disable the display of the progress bar?



Jon Peltier

disabling chart export progress bar
 
I believe this is impossible.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"extrnh" wrote in message
...
i have a macro that exports charts as gif files using the following
code:

Charts(i).Export Filename:=strWebPath & "images\" &
strChartName & ".gif", FilterName:="gif"

when each chart is exported, a progress bar is displayed. i would
like to disable the display of the progress bar form, but
Application.DisplayAlerts = False and Application.ScreenUpdating =
False do not work.

any ideas on how to disable the display of the progress bar?






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

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