Gareth,

Why not just record a simple macro to turn calculation to manual and another
to turn it back to automatic, and add a couple of buttons to a toolbar and
assign those macros to them. It is then there for you at a single click.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gareth" wrote in message
...
A file contains too many formula and the Status Bar doesn't work (display
number of rows when AutoFilter is used).

Is it possible to switch caculation to manual when AutoFilter is on and
back
to automatic when AutoFilter is switched off?

Thanks in advance.

Gareth