Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run, doesn't return to calling procedure
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run, doesn't return to calling procedure
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run, doesn't return to calling procedure
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling sub procedure | Excel Programming | |||
Problems calling a procedure in another application | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming |