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
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.
No. Pressing ESC generally aborts the loop.
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
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 !!!
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,
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
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.
That worked very well. Thanks for the tip.
Thanks Again...
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks