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

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

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

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

--
Kind regards,

Niek Otten

"pm" wrote in message ...
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

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

Make that

http://www.decisionmodels.com/

Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
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

--
Kind regards,

Niek Otten

"pm" wrote in message
...
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