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??

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??

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??