Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
worksheet_calculate | Excel Discussion (Misc queries) | |||
worksheet_calculate | Excel Discussion (Misc queries) | |||
Worksheet_Calculate Question | Excel Programming | |||
Worksheet_calculate() | Excel Programming | |||
worksheet_calculate **help** | Excel Programming |