Guys, I need to perform an action that would collapse an outline on another sheet. BUT I need to run it WITHOUT switching to that sheet.
The code I have for this now is the following:
Private Sub Chart_Activate()
    Sheets("A. Data Sheet").Select
    ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2
    Sheets("B. Graph Sheet").Select
    ActiveChart.ChartArea.Select
End Sub
So it basically switches to that other sheet, collapses the outline and switches back. Is it possible to run this same thing without changing sheets?
(the reason is that I have a Worksheet_Activate on my data sheet)