macro 2003 error 2007
Has someone any IDEA why excel 2007 does not run code made on 2003?
How i can enable the OnAction it says it does not exist, if open the same
on excel 2003 an below works fine but on 2007 error appears.
Any HELP ?
"MS GVE" wrote:
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
|