activate macro

  • Thread starter Thread starter Jase
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to use information in a cell to locate and send files using outlook 0
Setting Scope of name ranges to particular worksheet 2
Can I keep "Windows of active workbook check box" checked 1
Excel Equivalent of Access "Load" Event? 2
Help with Pivote Table 1
Counting multiple memberships 1
Multiple Workbooks using same macro 4

Back
Top