I am using VBA to creat a new workbook, which automatically generates
data table and chart ready for input of new data. I want to set a
event such that when data is added the minimum and maximum of th
y-axis adjust according to a function I have defined. I planned to us
the SeriesChange event, but do not know how to set this in a workboo
created using VBA. Is it possible to set VBA macros for a workboo
using a VBA macro from a different workbook?

If anyone has some tips or knows that this definately cannot be done
it would be great to hear from you so that I can stop wasting my tim
either way

--
biosc
-----------------------------------------------------------------------
biosci's Profile: http://www.excelforum.com/member.php...fo&userid=3282
View this thread: http://www.excelforum.com/showthread.php?threadid=52983