prevent recalculation of random data except in a "Calculate" macro

M

matt dunbar

Hi

is there a way to prevent recalculation except in a "Calculate" macro

i am turning on and off data in a chart by using a 1 or 0 multiplier on
the data

However this data is randomly generated so if i change this multiplier
value to 1 or 0 the random data updates also which i do not want

However i will make the data changet change but only by firing a macro
with a "Calculate" statement in a separate macro

thanks

matt



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
G

Guest

Set in Excel in menu Tools - Options - Calculation the
calculation to Manual instead of Automatic.

Regards
Klaus
 
T

Tom Ogilvy

Have you gone to tools=>Options, then the calculation tab and set
calculation to Manual?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top