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!

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

--
Regards,
Tom Ogilvy

"matt dunbar" wrote in message
...
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!