Use application.enableCancelKey false at the top of module and true
at the end of module
On 09/10/2011, hanumant shinde <arsfan2...@yahoo.co.in> wrote:
> 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
>
--
Sent from my mobile device
Regards
Rajan verma
+91 9158998701
--
----------------------------------------------------------------------------------
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
