Hi Paul, this is superb i never knew this thing. never even thought this might be happening. thanks for sharing it.
>________________________________ >From: Paul Schreiner <schreiner_p...@att.net> >To: excel-macros@googlegroups.com >Sent: Friday, 7 October 2011 4:05 PM >Subject: Re: $$Excel-Macros$$ A macro pauses execution for no reason > > >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 > > > -- ---------------------------------------------------------------------------------- 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