Freeze calculations in spreadsheets

[karraj]

Can we freeze calculations on one spreadsheet depending on a toggle switch.
My spreadsheets are big and that could save me time when i press f9 in the manual mode.
Thanks in advance

 

[Mark W.]

Tools | Options... Calculation Manual

 

[karraj]

Manual mode freezes calculation of all sheets. I want to selectively freeze calculations! Liek Sheet1 should update when I press F9 while sheet2 shouldnot.

 

[Juan Pablo González]

Control F9 calculates only the active sheet.

 

[karraj]

can this be done in VBa code. I mean this control f9!

 

[Juan Pablo González]

ActiveSheet.Calculate

wasn't that difficult ?

 

[karraj]

thanks,
deceptively simple