Marc,

From what you described I assume that you have a macro in the sheet, and this macro does not work as expected. So, when and how do you run a macro?
Is it autorun macro, or the user should click a button, or ...?

*Just notes. There are a lot of questions otherwise :
*- what do you mean "macro in my cell" ?
*- is it a formula or what, how does it look?
*... others follow

>I have a function (macro) in my cell and sometimes it seems the function is not executed... because when I put cursor in that cell and click the button with the green check sign... the refresh is made... it seems sometimes the events does not work at all? Another interesting thing, if I try to do programmaticaly calculate on my cell with the command range("my cell").calculate nothing change... I really need to put cursor and click ok like I said. Someone can help me?