Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |