Turn off automatic recalculations when moving between sheets

I notice that while moving between sheets my rand() formulas recalculate and mess up the previous figures I had fixed.

Is there a way to turn this off?

Thanks!