setting an event in an embedded chart from a differnet workbook

  • Thread starter Thread starter biosci
  • Start date Start date
B

biosci

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing data to an event handler 3
Embedded charts with events not working? 0
Why do charts disappear? 2
open workbooks when opening an excel file 1
ChartAdd event for embedded charts 10
Adjusting scale of an adjsuting chart 1
How do you chart data from multiple sheets within a workbook? 3
Import multiple workbooks to current workbook in specified row number 0

Back
Top