Application.Calculation
 

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

Application.Calculation
 

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

Application.Calculation
 

It is for users who are not that computer literate! Is it possible to do it
automatically?

Perhaps delete the Autofilter item on the Date Menu and replace it with
another item which would witch AutoFilter on and switch calculation to
manual????

Gareth

"Bob Phillips" wrote in message
...
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