Prevent Some/Allow Some cells to update on F9

[Arlen]

Hi, Folks!

Is there some way (using a Function or a checkbox, or even better, by simply
clicking on/off the cells in question) to choose which cells will and will
not update when I hit F9?

The purpose here is to make a dice roller for Yahtzee. I want to roll the
dice using RANDBETWEEN, but I want to be able to freeze certain dice on rolls
2 and 3.

I thank you for your time.

 

[Dave Ramage]

Arlen

Without resorting to VBA, you can use a circular reference + iteration to do
this. Go to Tools/Option and look at the Calculation tab. Allow itteration,
and set maximum iterations = 1.

Now your dice roll formula in B1 can be:
=IF(A1,B1,RANDBETWEEN(...))
....then link your checkbox to cell A1.

The (big) drawback to this is that the calculation settings are global and
are not saved with the workbook (in v2003 at least).

Cheers,
Dave

 

[Arlen]

Thanks, Dave!

Arlen

Without resorting to VBA, you can use a circular reference + iteration to do
this. Go to Tools/Option and look at the Calculation tab. Allow itteration,
and set maximum iterations = 1.

Now your dice roll formula in B1 can be:
=IF(A1,B1,RANDBETWEEN(...))
...then link your checkbox to cell A1.

The (big) drawback to this is that the calculation settings are global and
are not saved with the workbook (in v2003 at least).

Cheers,
Dave