Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation in left corner
Hi,
I have inherited a workbook that consolidates 8 other text files (data dumps). In the code the application.calculation is set to xlmanual and then at the end of the VBA the workbook is calculated and the application.calculation = xlAutomatic and the statusbar is set to false. Why would the Calculation prompt remain in the statusbar at the bottom left of the EXCEL application? Is there some type of error occurring that causes this to remain? If I close out of EXCEL and reopen, the Calculation is gone from the bottom corner. but as soon as I open the resulting workbook created from the VBA, it reappears AND the calculation option (radio button) is set to automatic. I've tried running a small script to clear the statusbar, but it keeps coming back. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation in left corner
James
application.calculation = xlAutomatic is pre xl97 I believe. Try Application.Calculation = xlCalculationAutomatic Application.Calculation = xlCalculationManual Gord Dibben Excel MVP On Tue, 29 Nov 2005 14:20:04 -0800, "James McDowell" wrote: Hi, I have inherited a workbook that consolidates 8 other text files (data dumps). In the code the application.calculation is set to xlmanual and then at the end of the VBA the workbook is calculated and the application.calculation = xlAutomatic and the statusbar is set to false. Why would the Calculation prompt remain in the statusbar at the bottom left of the EXCEL application? Is there some type of error occurring that causes this to remain? If I close out of EXCEL and reopen, the Calculation is gone from the bottom corner. but as soon as I open the resulting workbook created from the VBA, it reappears AND the calculation option (radio button) is set to automatic. I've tried running a small script to clear the statusbar, but it keeps coming back. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation in left corner
Sorry, the script reads "Application.Calculation = xlCalculationAutomatic"
"Gord Dibben" wrote: James application.calculation = xlAutomatic is pre xl97 I believe. Try Application.Calculation = xlCalculationAutomatic Application.Calculation = xlCalculationManual Gord Dibben Excel MVP On Tue, 29 Nov 2005 14:20:04 -0800, "James McDowell" wrote: Hi, I have inherited a workbook that consolidates 8 other text files (data dumps). In the code the application.calculation is set to xlmanual and then at the end of the VBA the workbook is calculated and the application.calculation = xlAutomatic and the statusbar is set to false. Why would the Calculation prompt remain in the statusbar at the bottom left of the EXCEL application? Is there some type of error occurring that causes this to remain? If I close out of EXCEL and reopen, the Calculation is gone from the bottom corner. but as soon as I open the resulting workbook created from the VBA, it reappears AND the calculation option (radio button) is set to automatic. I've tried running a small script to clear the statusbar, but it keeps coming back. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No filter results in bottom left hand corner | Excel Discussion (Misc queries) | |||
with Autofilter on, display count results in lower left corner wit | Excel Worksheet Functions | |||
AUTOFILTER-Totals on the left down corner marge do not appear | Excel Worksheet Functions | |||
How do I get the numbers to stay in the lower left hand corner? | Excel Discussion (Misc queries) | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) |