Application.Calculation

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

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
 
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)
 
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
 
Back
Top