+ Reply to Thread
Results 1 to 8 of 8

ctrl+break problem!

  1. #1
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    ctrl+break problem!

    Hello,
    I am struck in a problem. I used ctrl+break while my macro was running. It interrepted the macro as it should and the normal dialog window popped out:-
    'the code execution is interrupted'.
    Till here it was ok.

    Now a problem has arisen.Everytime i run my macro the same dialog window pops up again and again and my macro is not at all executed.I had closed and reopened my workbook several times but still the problem exists.

    Anyone please help me on this.
    Last edited by romperstomper; 10-04-2010 at 08:58 AM. Reason: mark solved

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: ctrl+break problem!

    Have you tried restarting Excel completely?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: ctrl+break problem!

    Yes, i have even logged on again.

  4. #4
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: ctrl+break problem!

    Now I am getting error:-
    User interrupt occur
    when i give continue command to :-
    this code cannot be executed.

    Any one please help me on this

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: ctrl+break problem!

    Try exporting all the modules, removing them from the workbook and then reimporting them.

  6. #6
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: ctrl+break problem!

    Thankyou for responding,
    The method you suggested didnot work.I have even tried even logging off but it didnot work.
    I am still getting the same error."Code execution has been interrupted".
    I also sometimes get the error-
    "Interrupte has been encountered. "
    Any one please help me out.

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: ctrl+break problem!

    Try adding:
    Please Login or Register  to view this content.
    as the first line of your code.

  8. #8
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: ctrl+break problem!

    Thanks, the code worked perfect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1