View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Worksheet_Calculate question

I have the following macro:

Private Sub Worksheet_Calculate()
If ThisWorkbook.Name = ActiveWorkbook.Name Then
Application.ScreenUpdating = False
If ChartObjects.Count 0 Then
With ChartObjects(ChartObjects.Count)
AxisScale .Chart
End With
End If
Application.ScreenUpdating = True
End If
End Sub

I want it to only run when for the worksheet that it's "attached" to. It
seems to be running whenever I change anything on another worksheet in the
workbook. What do I need to change?

Thanks in advance,
Barb Reinhardt