Hello,
I am trying to figure out if I can have 2 custom buttons.
1 to turn off auto calc.
1 to turn on auto calc

is this possible?
I guess i could write custom vba code.
but I am looking in the customize. and I cannot find them, already created.

thanks

As far as I know, you'll have to write a couple of VBA macros to do that and
assign them to the 2 buttons.

Sub TurnOnCalculation()
Application.Calculation = xlCalculationAutomatic
End Sub

Sub TurnOffCalculation()
Application.Calculation = xlCalculationManual
End Sub


--
Regards,

Juan Pablo González

"greg" <(E-Mail Removed)> wrote in message
news:%23$z$(E-Mail Removed)...
> Hello,
> I am trying to figure out if I can have 2 custom buttons.
> 1 to turn off auto calc.
> 1 to turn on auto calc
>
> is this possible?
> I guess i could write custom vba code.
> but I am looking in the customize. and I cannot find them, already
> created.
>
> thanks
>
>