How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks?

[pm]

hello,

is there any possibility of limiting 'calculate' (F9) to particular cell, range,
sheets, worksbooks?
i have about 70 excel files (weight ca 300 MB). Automatic calculation is off.
manual last about 1 minute (with 512 MB RAM), what in effect last about several
houres when i calculate files in loop of two variables
limiting (restricting?) calculate instruction to cells, range, sheets would
accelerate all process

PS. how can i disable macro in sheet's code when another macro is running?
and enable it after ...
eventually, how disable macro when F9 is pressed?

regards

 

[Niek Otten]

You can indeed calculate Sheets (SHIFT+F9) and ranges (VBA needed).

Lots of information about Excel's calculation mechanisms here on Charles
William's site:

www. decisionmodels.com

 

[Niek Otten]

Make that

http://www.decisionmodels.com/

Kind regards,

Niek Otten