| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inadvertently created loop
I have accidentally put in some code which I now cannot stop from running.
Can someone please help me. How do I get into the script editor when a message box keeps coming up: I can't even get in to post my code. Please help me |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inadvertently created loop
hold down the shift key when you open the file. This should keep the Open
event from running,. -- Reards, Tom Ogilvy "marianne" wrote in message ... I have accidentally put in some code which I now cannot stop from running. Can someone please help me. How do I get into the script editor when a message box keeps coming up: I can't even get in to post my code. Please help me |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inadvertently created loop
thank you for the prompt reply. I have users trying to get into the file and
I'm holding up people from doing their job. That didn't work. Any other suggestions? I've tried the ctl key, but that doesn't work either. HELP "Tom Ogilvy" wrote: hold down the shift key when you open the file. This should keep the Open event from running,. -- Reards, Tom Ogilvy "marianne" wrote in message ... I have accidentally put in some code which I now cannot stop from running. Can someone please help me. How do I get into the script editor when a message box keeps coming up: I can't even get in to post my code. Please help me |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inadvertently created loop
Try setting macro security to medium (Tools-Options-Security-Macro
security). When you open your spreadsheet, it will ask if you want to enable or disable macros. Say disable. Then alt+F11 to into the editor to fix it. Len marianne wrote: I have accidentally put in some code which I now cannot stop from running. Can someone please help me. How do I get into the script editor when a message box keeps coming up: I can't even get in to post my code. Please help me |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inadvertently created loop
Implied in Tom's reply was that you would use the SHIFT key to
open the file without running the loop, and then *FIX THE CODE*. Try pressing CTRL+BREAK while you're looping -- you should then get a message box stating "Code Exaction Interrupted". Then go into the VBA and fix the code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "marianne" wrote in message ... thank you for the prompt reply. I have users trying to get into the file and I'm holding up people from doing their job. That didn't work. Any other suggestions? I've tried the ctl key, but that doesn't work either. HELP "Tom Ogilvy" wrote: hold down the shift key when you open the file. This should keep the Open event from running,. -- Reards, Tom Ogilvy "marianne" wrote in message ... I have accidentally put in some code which I now cannot stop from running. Can someone please help me. How do I get into the script editor when a message box keeps coming up: I can't even get in to post my code. Please help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inadvertently scrolling when double clicking a field. | Excel Discussion (Misc queries) | |||
| Fill color changes inadvertently... | Excel Discussion (Misc queries) | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
| Private Sub Running Other Private Sub Inadvertently | Excel Programming | |||
Linear Mode
