VBA calculate sheet when opened

[Russk68]

Hello all,

I have a workbook with many sheets and manual calculation is default by other VBA trigger.

I am in need of code that will calculate a sheet when it is opened and also other sheets that are linked to it as well.

Example:
I open sheet 1.
Sheet 1 calculates.
I also want sheets 3,5and 7 to calculate as well when sheet 1 is opened.

Your help is greatly appreciated!

Russ

 

[Russk68]

After thinking about this further, I would like to calculate sheets when exiting a sheet.
This what I have tried:

Private Sub Worksheet_Deactivate()
ThisWorkbook.Sheets("Distro").Calculate
ThisWorkbook.Sheets("Multi Breakdown").Calculate
ThisWorkbook.Sheets("Assign Looms").Calculate
ThisWorkbook.Sheets("Locations").Calculate
ThisWorkbook.Sheets("Patch By Universe").Calculate
End Sub

 

[mrshl9898]

[COLOR=#333333]Private Sub Worksheet_Deactivate()[/COLOR]
[COLOR=#333333]Sheets("Distro").Calculate[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

This works for me, are you putting the macro on the sheet or in a module?

 

[Russk68]

On the sheet.

I am getting this error:

Compile error:
Ambiguous name detected: Worksheet_Deactivate

I am also using other VBA on the sheet as well like:

Private Sub Worksheet_Deactivate()
ThisWorkbook.Sheets("Multi Build").Application.Calculation = xlManual
End Sub

 

[mrshl9898]

I'd say it's ambiguous as you're using the event multiple times.

Can you not put all the code in the one Sub?

 

[Russk68]

That worked!
Thank you very much!