2003 / W7
This Userform application has been running for a while. On opening of the workbook it has the statement
Application.Calculation = xlCalculationAutomatic
after which it Opens or Shows the userform.
A couple of times in the last few days the application, even after this open, ended up in "manual calculation" mode. Any ideas on how this could happen? No other Excel spreadsheet open or opened between uses.
I have been using the following routine to set worksheets that would burn cycle times to sleep until needed.
Where MyArray has the list of worksheets not needed during this phase of the application. This has not been changed since I started the program a month + ago.
This Userform application has been running for a while. On opening of the workbook it has the statement
Application.Calculation = xlCalculationAutomatic
after which it Opens or Shows the userform.
A couple of times in the last few days the application, even after this open, ended up in "manual calculation" mode. Any ideas on how this could happen? No other Excel spreadsheet open or opened between uses.
I have been using the following routine to set worksheets that would burn cycle times to sleep until needed.
Code:
For Each wsht In MyArray
With wsht
.EnableCalculation = False
End With
Next wsht
Where MyArray has the list of worksheets not needed during this phase of the application. This has not been changed since I started the program a month + ago.