Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello!
I have application in XLA file. When I run that XLA over AddIn or from directory I have set in that XLA on ThisWorkbook event Workbook_Open() Inside I have two lines: Application.Calculation = xlCalculationManual Application.OnEntry = "myProcedure" Problem is that this lines don't run and I get error msg 1004: Method 'Calculation' of object '_Application' failed. If I run that later then overything is fine. I also try to put that two lines in Workbook_Activate() event but then that lines never get processed. This commands has to be set before user open any other workbook. Does anybody already had the same problem and how to solve that? Best regards, Billy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Application.Calculation=xlCalculationManual causing run time error? | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |