Macro to refresh another worksheet when tab is activated

[juliettelam]

Hello

I'm trying to make a macro that will calculate another worksheet (Master List) in the workbook when the tab is activated.
I know that refreshing the other worksheet (master list) is

Please Login or Register  to view this content.

But I would like to refresh this master worksheet when I click into another tab (account summary), not the master worksheet tab. Does anyone know how to create a macro that calculates the values for specific worksheet when another worksheet is activated? Thanks!

[Norie]

Replace Me with a reference to the sheet you want to calculate and put the code in the 'Account Summary' sheet's module.
[code]
Private Sub Worksheet_Activate()


Worksheets("Master List").Calculate


End Sub