We have a Excel sheet that loads raw data from csv files.
On excelö 2003 and below works perfectly but on 2007 we get application or
object defined error.
When calling OnAction from ChartObjects, I'd tried to find a soilution and
so far none has been satisfactry, Is ther a way not to recode and use a kind
of compatibility mode...
IS quite annoing that former versions of OFFICE cant be supported.
example :-----
Option Explicit
Private Sub Worksheet_Activate()
Dim ch_ As ChartObject
For Each ch_ In Me.ChartObjects
ch_.OnAction = "'" & ThisWorkbook.Name & "'!Cover.ZoomChart"
Next ch_
Range("B3").Select
End Sub