View Single Post
  #1   Report Post  
TEAM
 
Posts: n/a
Default Chart Animated Sine Wave


J-walk's excel 2000 vba book comes with an animation file that uses
interations to produce a fluccuating sine wave. Why is it that if I
copy the exact same sheet to a new workbook and copy the associated
macro to that new workbook, the animation does not work properly. If
you have not seen this (or the book) and need more details, let me
know.

I am trying to understand this better and it thoroughly confused me. I
can have both workbooks open (j-walks and the new book) with access to
his macro and the one I duplicated from his. Using the new workbook I
cannot get either macro to animate the graph. Using his workbook, I
can get both macros to animate it.

I have tried turning on iterations, but that did not make a difference.
When I run the macros it recalculates all of the chart source data, but
the chart does not change.

What am i doing wrong??


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=393457