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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks