Chart data refresh & printing

[Bruce]

In an XL2000 work book, I have a drop down validation box that selects
a name from another sheet. After selection of the name, cells
alongside that validation box are updated from that other sheet. Below
is a chart that gets seems to get refreshed & redrawn with no
problems. I have even added two VB buttons to select the next or
previous name from the list, looping around at end. Once again no
problems. A second chart on the same sheet as the prevoius chart uses
the same dropdown box, this chart using different calculations. Still
no problem. Name is selected or next or previous, both charts
automatically update.

The problem:
I am trying to write code that will step through all names, refreshing
the charts, and printing out the sheet with the charts. All I get is
the name & charts currently being displayed.

Any ideas

TIA,

Bruce

 

[Stephen Bullen]

Hi Bruce,

I am trying to write code that will step through all names, refreshing
the charts, and printing out the sheet with the charts. All I get is
the name & charts currently being displayed.

It might help if you included the text, but a few wild guesses might
help:

1) Are you setting calculation to Manual at the start of the code? If
so, you'll need to do ActiveWorksheet.Calculate to get the charts to
refresh.

2) Do you have ScreenUpdating turned off? It's unlikely (but I guess
possible) that the charts are not redrawing themselves because of that.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Bruce]

Hi Bruce,
2) Do you have ScreenUpdating turned off? It's unlikely (but I guess
possible) that the charts are not redrawing themselves because of that.

Setting it to true worked - thanks.

Bruce