Coding to prevent macro calculations unless on a specific worksheet

[spurs]

I have a workbook that has many worksheets. One of these worksheets is named "Plot" which graphs data.

Right now, whenever I do an entry on the worksheet "Main", I run a macro called "Update" which does all of the calculations needed and updates the workbook. This is a slow process and takes 2 seconds to do all of the updates.

I suspect that I can save a lot of delay time by not doing updates to calculations associated to plot the graph on worksheet "Plot".

What I would like to do is add code to the "Update" macro that recognizes that I am on the worksheet "Main" and am not looking at other worksheets so I want to prevent doing background calculations to update the graphs. However if I move off of worksheet "Main". or "save" the workbook, I want to make sure that the calculations are done.

What are some of the lines of code that I can use to:
a) recognize that I am on worksheet "Main"
b) trigger the macro "Update" when I leave worksheet "Main"
c) recognize that I am saving the workbook and allow "Update" to also do the graphical calculations

 

[Nutster]

a)

If ActiveSheet.Name = "Main" Then

End If

b) Whenever the focus moves from a worksheet, the Worksheet.Deactivate event is triggered. You can use the Worksheet_Deactivate event handler in the code block for the Main worksheet to do things when the worksheet loses focus. This event will be triggered for lots of reasons, not just activating another sheet; this includes the focus moving to another application or the desktop.

Private Sub Worksheet_Deactivate()

End Sub

c) Just before the worksheet is saved, the Workbook.BeforeSave event is triggered. Putting a Workbook_BeforeSave handler in the ThisWorkbook code block will let you call update just before you save the workbook.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

End Sub

 

[Nutster]

c) Another thing you can do is turn on the Calculate upon Save under options.

 

[spurs]

This is fantastic
thank you