Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Calculation Problems | Excel Worksheet Functions | |||
Application Calculation Error | Excel Programming | |||
Application.Calculation=xlCalculationManual causing run time error? | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
Application.Calculation exception | Excel Programming |