| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Some/Allow Some cells to update on F9
Thanks, Dave!
"Dave Ramage" wrote: 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" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent copying of cells | Excel Discussion (Misc queries) | |||
| Prevent edit of cells | Excel Worksheet Functions | |||
| Prevent Excel putting full filename in external links on update | Excel Discussion (Misc queries) | |||
| How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
| Lock Cells to Prevent Changes | Excel Discussion (Misc queries) | |||
Hybrid Mode
