Caculating Cells

[Woodstar]

I have a workbook where each cell has a formula to calculate cells in other work sheets. Problem is everything I move from sheet to sheet or filter I have to wait until all the cells are recalculated. Is there a macro that can be built to toggle on and off to calculate when I want it to? Or does excel have a built in function for that?

Many thanks to this board for you have solved several problems for me. Again thanks!

 

[venkat1926]

you can have two buttons one "automatic" and other "manual" anda assign them to these
and 2 macros . Please remember after the work is over to click "automatic" button (or have an event code before closing the workbook the macro "automatic" will be invoked)

Sub automatic()
With Application
        .Calculation = xlAutomatic
        End With
End Sub

Sub manual()
With Application
        .Calculation = xlManual
        End With
End Sub

There may be more elegant solutions.

a

 

[Woodstar]

Thanks! That's exactly what I wanted; worked like a champ. Like I said I've always got an answer at this board. Again Thanks