Cyberdude
03-29-2006, 01:31 PM
I let Excel create a macro for me and it generated two statements that I don't understand:
Sub TestSelection()
'Click on chart
ActiveSheet.ChartObjects("Chart 134").Activate
ActiveChart.Axes(xlValue).MajorGridlines.Select
'Click on window to deselect chart
ActiveWindow.Visible = False
Windows("Rydex Benchmk.xls").Activate
Range("DX23").Select
End Sub It's the red statements I don't understand. It looks like it's making the window invisible, but that didn't occur. What did the "Windows....Activate" do??
Sub TestSelection()
'Click on chart
ActiveSheet.ChartObjects("Chart 134").Activate
ActiveChart.Axes(xlValue).MajorGridlines.Select
'Click on window to deselect chart
ActiveWindow.Visible = False
Windows("Rydex Benchmk.xls").Activate
Range("DX23").Select
End Sub It's the red statements I don't understand. It looks like it's making the window invisible, but that didn't occur. What did the "Windows....Activate" do??