Thanks for all your answers guys!

Rob I use your suggestion and I have to say that until now work as it should.

Regards,
Billy


"Rob Bovey" wrote in message ...
Hi Billy,

Modify the code in your Workbook_Open event as follows:

ThisWorkbook.Activate
Application.Calculation = xlCalculationManual
Application.OnEntry = "myProcedure"

You need to have a workbook active before you can set the Calculation
property and although it seems counterintuitive, you can "activate" your
add-in workbook to serve this purpose even though it's not visible.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Billy" wrote in message
om...
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