View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Missing code in macro

You probably already know that there are some things that the recorder will
not record. It basically records cell/range selections and keystrokes.

"Lee" wrote:

I recorded a macro but when I go into the editor a lot of the code is
missing. All I see are objects that are activated or selected (see below).
I am using Excel 2007 on WindowsXP. Does anyone know what is going on? I
never had this problem with Excel 2003.
Thanks in advance,
Lee

Sub Macro2()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Legend.Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartTitle.Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveSheet.ChartObjects("Chart 1").Activate
End Sub