Please help,
I have upgraded to Office 2007 and one of my Excel reports no longer works, the problem is I cant select an Option Button on a chart using VBA.
This is the code and line 2 fails with:
Run-time error '-2147024809 (80070057)
The item with the specified name was not found
Sheets("Chart1").Select
ActiveChart.Shapes("Option Button 1").Select
With Selection
.Value = xlOn
.LinkedCell = ""
.Display3DShading = False
End With
This will work if I create a chart on a sheet but not on a chart.
I also considdered using an ActiveX Option Button but that was greyed out
I have upgraded to Office 2007 and one of my Excel reports no longer works, the problem is I cant select an Option Button on a chart using VBA.
This is the code and line 2 fails with:
Run-time error '-2147024809 (80070057)
The item with the specified name was not found
Sheets("Chart1").Select
ActiveChart.Shapes("Option Button 1").Select
With Selection
.Value = xlOn
.LinkedCell = ""
.Display3DShading = False
End With
This will work if I create a chart on a sheet but not on a chart.
I also considdered using an ActiveX Option Button but that was greyed out
