Hi,

after calling a procedure in another workbook with
Application.Run the program doesn't find back to
the calling procedure.

Are there common reasons for this behaviour?
Thank you

Regards
Werner

Excel XP SP3
Win XP SP3

Does the procedure called by Run execute properly? Is the procedure that
uses Run executed from a worksheet cell?


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Werner Rohrmoser" <werner-(E-Mail Removed)> wrote in message
news:908e65fa-e0da-4c52-82c0-(E-Mail Removed)...
> Hi,
>
> after calling a procedure in another workbook with
> Application.Run the program doesn't find back to
> the calling procedure.
>
> Are there common reasons for this behaviour?
> Thank you
>
> Regards
> Werner
>
> Excel XP SP3
> Win XP SP3

Yes, the procedure executes and finishes properly.
It's started by an Command Button from the Forms Tool Bar, which is
located on a worksheet.

I fear I have to look deeper into my colleagues "spaghetti" program,
this was what I tried to prevent with my global question.

I tried some ideas, what might have caused the malfunction,
but only when I closed the workbook with the procedure I have called
by VBA than it doesn't come back.

Anyway thnaks for your reply.

Werner