Hi,

I have set a Auto_Open VBA code to switch off Calculations when opening a large workbook which works fine.

However i would now like to calculate each worksheet as i select that individual worksheet

I know you can use the 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
code but this requires the amendment of a specified cell on that worksheet to activate the code, i want it to happen automatically when opening that worksheet without having to amend any cell.

Can this be done?

Thanks

Simon