View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stupler
 
Posts: n/a
Default Stop Recalculating?


I'm hoping that someone could help me with a problem I have with an
Excel game I'm making.
'This is the spreadsheet I am having problems with'
(http://uk.geocities.com/ueverwondered/DONDExcelHelp.xls). I'm hoping
this will help me in explaining my problem, since I'm pretty new to the
macro side of things.

It doesn't matter too much if you choose to run macros or not. The
problem lays with the cell to the right of the "Dealt at:" text. It
works by getting the number in the cell next to the "Offer:" text. If
the player types "deal" into the cell above the "Dealt At:" cells, the
cell to the right of the "Dealt At:" text will display whats in that
cell.
But if the player plays on, that number to the right of the "Dealt At:"
text will change too, which I'd like to remain at the first number it is
(when the player typed "deal").

Is it a matter of stopping it recalculating or something else?

(The game is'nt finished, by the way! :) )


--
stupler
------------------------------------------------------------------------
stupler's Profile: http://www.excelforum.com/member.php...o&userid=32884
View this thread: http://www.excelforum.com/showthread...hreadid=526882