View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default call function from another wb : problem

Hi Francois,

Have you tried stepping through your code. Put a break point F9 on the first
line in UpdateMb, or the single statement "Stop" without quotes. When the
code stops press Ctrl-L to see what called the function. Step through with
F8 or run to the next break or stop statement with F5. (Also look at Ctrl
F8, Shift F8 & Ctrl+Shift F8)

Off topic - did you sort out the problem you posted a while ago re showing
an Application.Dialog called from Macro-5 dialogsheet code.

Regards,
Peter T

"François" wrote in message
...
Hello,
This is the situation

Function UpdateMb

<instructions
application.run(<workbookname!<modulename.<functi onname())
<instructions

End function

When the application.run cmd is running, there is no runtime error.

However
the function UpdateMb is rerun immediately without having run the function
from the other wb.

Thanks for your help
Francois.