setting an event in an embedded chart from a differnet workbook
 

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

setting an event in an embedded chart from a differnet workbook
 

See Chip Pearson's page on this topic

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"biosci" wrote in
message ...

I am using VBA to creat a new workbook, which automatically generates a
data table and chart ready for input of new data. I want to set an
event such that when data is added the minimum and maximum of the
y-axis adjust according to a function I have defined. I planned to use
the SeriesChange event, but do not know how to set this in a workbook
created using VBA. Is it possible to set VBA macros for a workbook
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 time
either way.


--
biosci
------------------------------------------------------------------------
biosci's Profile:
http://www.excelforum.com/member.php...o&userid=32827
View this thread: http://www.excelforum.com/showthread...hreadid=529833