| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there a "workbook.calculation" command ??
hi all !
i have my 3 workbook opened, runnin the same macro each, with disabled the calculation of page , and i use Application.calculation for make it calculating. but like that it calculates 3 times per cycle each page .. i have a office xp.. is there any solution?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there a "workbook.calculation" command ??
For the active sheet you could use this:
ActiveSheet.Calculate HTH, Paul -- "N+" wrote in message ... hi all ! i have my 3 workbook opened, runnin the same macro each, with disabled the calculation of page , and i use Application.calculation for make it calculating. but like that it calculates 3 times per cycle each page .. i have a office xp.. is there any solution?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there a "workbook.calculation" command ??
activesheet no useful for my case ty !
i will set the calculate in1 macro for all, it is not perfectly clean but it works ! "PCLIVE" wrote: For the active sheet you could use this: ActiveSheet.Calculate HTH, Paul -- "N+" wrote in message ... hi all ! i have my 3 workbook opened, runnin the same macro each, with disabled the calculation of page , and i use Application.calculation for make it calculating. but like that it calculates 3 times per cycle each page .. i have a office xp.. is there any solution?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| ie Command to Wait for "File Download" and "Save As" windows | Excel Programming | |||
| command button and the "enter" and "tab" keys | Excel Programming | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
| Is there a "replace" or "Substitute" command in Excel's VB? | Excel Programming | |||
Linear Mode
