activate macro

J

Jase

I have 2 worksheets open at once, I want to update one particular worksheet
everytime that I click on it. Is their a way to do that?
 
S

ShaneDevenshire

Hi Jase,

By update I presume you mean recalculate. If the two files refer to each
other and there are no external references to closed workbooks, the files
will update automatically unless you are in manual recalc mode. If that is
the case then add the following code to the thisWorkbook object in the Visual
Basic Editior for both files:

Private Sub Workbook_Activate()
Application.Calculate
End Sub
 
Top