Simple recorded macro crashes on playback. Why?
I have a bar chart and a line chart on a sheet. One covers the other, so
that it appears that there is only one chart. I recorded a macro that sends the visible chart to the back, exposing the hidden one. Pretty simple, but when I play the macro back, it crashes with error "Object doesn't support this property or method". Here is the macro: Sub CHART_SHOW_BAR_CHART() Range("A1").Select ActiveSheet.ChartObjects("Chart 40").Activate 'the visible chart ActiveChart.ChartArea.Select Selection.ShapeRange.ZOrder msoSendToBack 'exposing the hidden chart ActiveWindow.Visible = False Windows("MSTATS.xls").Activate Range("A1").Select End Sub Any help would be appreciated. If possible, is there a way to get rid of the line " Windows("MSTATS.xls").Activate" because the workbook will have a filename linked to the date. TIA Paul |
Simple recorded macro crashes on playback. Why?
Try
Sub CHART_SHOW_BAR_CHART() Range("A1").Select ActiveSheet.ChartObjects( _ "Chart 40").ShapeRange.ZOrder msoSendToBack 'exposing the hidden chart End Sub -- Regards, Tom Ogilvy "Paul" wrote in message ... I have a bar chart and a line chart on a sheet. One covers the other, so that it appears that there is only one chart. I recorded a macro that sends the visible chart to the back, exposing the hidden one. Pretty simple, but when I play the macro back, it crashes with error "Object doesn't support this property or method". Here is the macro: Sub CHART_SHOW_BAR_CHART() Range("A1").Select ActiveSheet.ChartObjects("Chart 40").Activate 'the visible chart ActiveChart.ChartArea.Select Selection.ShapeRange.ZOrder msoSendToBack 'exposing the hidden chart ActiveWindow.Visible = False Windows("MSTATS.xls").Activate Range("A1").Select End Sub Any help would be appreciated. If possible, is there a way to get rid of the line " Windows("MSTATS.xls").Activate" because the workbook will have a filename linked to the date. TIA Paul |
All times are GMT +1. The time now is 08:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com