VBAProIWish
Well-known Member
- Joined
- Jul 6, 2009
- Messages
- 1,027
- Office Version
- 365
- Platform
- Windows
Hello All,
I used the macro recorder to record the following...(recorded code below)
1. Select a chart
2. Select "Design" in the ribbon
3. Select "Select Data"
4. Select my desired data range
5. Press ok
6. Insert a template
However, the only part that's recorded is selecting the chart and inserting a template.
The recorder completely ignored steps 2-5.
Does anyone know why?
Thanks much
I used the macro recorder to record the following...(recorded code below)
1. Select a chart
2. Select "Design" in the ribbon
3. Select "Select Data"
4. Select my desired data range
5. Press ok
6. Insert a template
However, the only part that's recorded is selecting the chart and inserting a template.
The recorder completely ignored steps 2-5.
Does anyone know why?
VBA Code:
Sheets("Slide 1").Select
ActiveSheet.ChartObjects("Chart 1").Activate
Application.CutCopyMode = False
ActiveChart.ApplyChartTemplate ("C:\Charts\_Slide 1.crtx")
Thanks much