This worked fine in a test I just ran. Did this work for you in Excel 2003?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"turen" wrote in message
...
I am trying create a chart 'on the fly' based on the user selected data
range
in Excel 2007. I was trying to use Jon Peltier's 'interactive chart
creation' VB scripts. Somehow it does not work on Excel 2007. After
Jon's
interactiveChartCreation.xls opens, both input boxes does not work,
meaning
one can not input any data by mouse selection. I tried to click 'ok', but
it
only selected the input box. I hope Jon or some one else can see this and
offer some help. Thank you all very much for your tips.