Autocalculation settings when multiple spreadsheets open

[Bryan Linton]

I've created a spreadsheet that turns off autocalculation when it opens. A
user recently noticed that when that spreadsheet is open, autocalculation is
also turned off for any other open spreadsheets. Is there a simple way
around this, or do we need to simply teach our users to live with this fact
and work around it by opening and closing spreadsheets as needed? I don't
think it's possible to have different options set for simultaneously open
spreadsheets, but I figured I'd check here just in case.

Thanks,

Bryan

 

[Norman Jones]

Hi Bryan,

I've created a spreadsheet that turns off autocalculation when it opens

Try, instead, setting calculation to manual when the workbook is activated
and restoring calculation to automatic when another workbook is activated.

In the workbook's ThisWorkbook module paste the following :

Private Sub Workbook_Activate()
Application.Calculation = xlCalculationManual
End

Private Sub Workbook_Deactivate()
Application.Calculation = xlCalculationAutomatic
End

 

[Norman Jones]

Hi Bryan,

In each Sub replace

End

with

End Sub