Cell refreshing alteration.

Hello,


This might be a tricky Problem, beyond even excels programming itself. Any help would be very much appreciated. I am using excel 2007.

I built a =RANDBETWEEN Electronic dice. When you refresh cells, or press F9 it rolls the dice (I got it from a tutorial)

I also have a drop down menu. When you select a option in the drop down it resets the dice. I want to stop this.

I made a button that when you click it, it rolls the dice.

Ideally I want to make it so you hit the button, it rolls the dice. Then you go and select different drop down menus with out effecting certain cells, as wells as with out effect the dice rolls.

Maybe a way to make it do only certain cells (The dice cells) only refresh when you click on the button.


Any advice would be appreciated,

Thank You.