Ok got it...
See here is how it can be done. Each macro is an event and the macro wont
refresh unless somethings trigers it... like a button click. Anyway if you
want that macro to run when a particular chart gets active... Go to VB script
of that chart (Press alt+f11 and browse to the chart) In the chart script
these lines will automatically appear...

Private Sub Chart_Activate()

End Sub

Just insert the macro you want to be executed in between these lines. That
should do the trick. Also if the macro doesn't run till a particular
worksheet is not activated then use ActiveSheet function...

Vikrant

"Biti" wrote:

Thanks Vikrant,
I do not want the users to do much of clicking. I want them to open
the workbood and see the chart the first time they open. The chart
doesn't get built until the coresponding worksheets are activated. The
macro simply converted the data type to number, until that conversion
is made the chart page would not show any chart. If a user chosse to
open a chart sheet first, i want the macro on the other sheet to
execute so the chart works as it is suppose to. I could send you
example if you want to see it.
Thanks,
Biti