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
