LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Re-starting a project but avoiding recursion???

Ladies and Gents -
I have a project, several subs and functions and forms. While running one of
the subs, it is checking to see if the user wants to add some new data. If
that is true, then it creates a new entry on the worksheet (I am using the
worksheet like a database). But then, at that point, after the new data is
added at the end of the sheet, I need it to re-start, by running the "main"
macro that the user normally activates when the sheet first opens (I have a
button on the worksheet for this).

If I use the Call method, it seems that there is some sort of recursion
going on. Weird things happen... including a Windows fatal error.

How can I jump out of a sub, and then restart the entire project by starting
the original macro again?

Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Managing Multiple Projects: Avoiding Project Overload Duncan[_2_] Excel Discussion (Misc queries) 2 January 7th 08 02:29 PM
Recursion in VBA macros? Peter Chatterton[_4_] Excel Programming 5 November 27th 06 07:27 PM
Abort recursion Mike NG Excel Programming 2 June 29th 05 09:08 AM
Recursion Mike NG Excel Programming 4 June 2nd 05 11:07 PM
Worksheet_Change Recursion ARGHH! DBAL[_2_] Excel Programming 6 July 1st 04 11:55 PM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"