Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
activate macro
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
activate macro
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 -- Cheers, Shane Devenshire "Jase" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet- activate macro | Excel Discussion (Misc queries) | |||
activate macro only in sheet2 | Excel Worksheet Functions | |||
activate a cell value through a macro | Excel Discussion (Misc queries) | |||
Formula to activate macro | Excel Worksheet Functions | |||
Ways to activate a macro | Excel Discussion (Misc queries) |