View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_9_] Ed[_9_] is offline
external usenet poster
 
Posts: 194
Default "This macro calls that macro, which calls .."-how many?

I've jsut finished looking at all the code I have to complete a certain
project. I realized that in some places, I have a macro calling a macro,
which calls another one. In fact, it may go four deep, and the "parent"
won't close until the last "grandchild" is completed. How many can be
*SAFELY* stacked up like this? Is there a point at which you reach
instability, with workbooks opening and closing, saving and claculating in
macros within macros?

Ed