| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a hyperlink cell-specific between two XL sheets? | Excel Discussion (Misc queries) | |||
| Calculate max value in specific range | Excel Discussion (Misc queries) | |||
| Limit search range then loop thru' each cell...a bit stuck... | Excel Programming | |||
| limit worksheet view to specified cell range | Setting up and Configuration of Excel | |||
| Trying to limit .Find to a specific range | Excel Programming | |||
![pm[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
