+ Reply to Thread
Results 1 to 9 of 9

Excel caught looping script

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Excel caught looping script

    Hi,

    I have an excel workbook that is caught in a never ending loop when the workbook opens. Is there anyway to open the script editor to modify the code causing the loop?

    Thank You, Mike
    Last edited by realniceguy5000; 11-12-2008 at 02:39 PM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    No. Pressing ESC generally aborts the loop.

  3. #3
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951
    No,I tried that. It is a message box with a yes and no. when you press one of the buttons you just get a windows ding. Nothing happens? I can't get into the editor to edit the script.

    anyother idea's

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Why not step through the code to see what is happening instead of running it all at once.

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  5. #5
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951
    The code starts as soon as I open the workbook.So I cant get into the editor to change the code. so when the workbook open script runs all I have at that point is just a message box that asks yes or no. both buttons do nothing? but beep.

    Thank You,

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    You could open the workbook with macro disable then Edit out the code in ThisWorkbook and place the code in a normal module and save and reopen for testing to see what is causing the issue.

    VBA Noob

  7. #7
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    Obviously, you need to set Tools > Macro > Security greater than low to disable macros.

    Ctrl+Break works sometimes but if ESC is not working, I doubt it will break this way either.

  8. #8
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951
    That worked very well. Thanks for the tip.

    Thanks Again...

  9. #9
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    What worked? Was it the disable macros?

    With the macros disabled, you won't be able to Step through the code. What you can do is to type the word STOP into your macro. I would just put it at as the first line of a Workbook Open event. When you then save and open it with macros enabled, it will stop there.

+ 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