RealName: Hervé RICHARD

Hello NGs,

My table has so many formulas, that the VBA code I wrote gets disregarded
upon opening.
If I write Application.CalculateFullRebuild or press F9, the whole table
gets calculated only once...
How can I switch on or off the calculation ?

Thank you in advance for any constructive proposal.

In VBA

Application.Calculation = xlCalculationAutomatic

and

Application.Calculation = xlCalculationManual

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Froggy" <(E-Mail Removed)> wrote in message
news:9C4E36BC-6099-47B4-B9C3-(E-Mail Removed)...
> RealName: Hervé RICHARD
>
> Hello NGs,
>
> My table has so many formulas, that the VBA code I wrote gets disregarded
> upon opening.
> If I write Application.CalculateFullRebuild or press F9, the whole table
> gets calculated only once...
> How can I switch on or off the calculation ?
>
> Thank you in advance for any constructive proposal.

It works!!!
Thank you.

"Bob Phillips" wrote:

> In VBA
>
> Application.Calculation = xlCalculationAutomatic
>
> and
>
> Application.Calculation = xlCalculationManual
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Froggy" <(E-Mail Removed)> wrote in message
> news:9C4E36BC-6099-47B4-B9C3-(E-Mail Removed)...
> > RealName: Hervé RICHARD
> >
> > Hello NGs,
> >
> > My table has so many formulas, that the VBA code I wrote gets disregarded
> > upon opening.
> > If I write Application.CalculateFullRebuild or press F9, the whole table
> > gets calculated only once...
> > How can I switch on or off the calculation ?
> >
> > Thank you in advance for any constructive proposal.
>
>
>