And if that doesn't work, from my experience, this normally goes away once you've restarted the operating system.
Regards, Sam On Fri, Oct 7, 2011 at 4:05 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > You said that it stops at a "random" point. > It it the same point every time? or a different ("random") point? > > I've encountered something similar, it's as if a breakpoint is being saved. > Even when I exit Excel and re-open the file. > > When it stops, I was able to select Debug-> Clear_All_Breakpoints > (ctrl-shift-F9) > then save it, and the stopping... stopped. > > > *Paul* > > ----------------------------------------- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----------------------------------------- > > > ------------------------------ > *From:* carl.malmquist <carl.malmqu...@gmail.com> > *To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > *Sent:* Thu, October 6, 2011 6:16:36 PM > *Subject:* $$Excel-Macros$$ A macro pauses execution for no reason > > A coworker sent me a workbook with a macro that runs fine on my > laptop. On her laptop, the macro runs and at a random point within > the macro, it pauses, as if that spot in the code has a break point. > Hitting run restores the macro to running and it completes normally. > > Has anyone experienced with with their own code? Does anyone have any > suggestions for a fix? > > Thanks. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel