Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
Hi folks....this is a bit embarrasing!
I created a crappy bit of code by accident in my auto-open macro, and can't get into my program to delete it! Can someone tell me the key combination to stop running code while its executing? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
Escape key or if that doesn't work Ctrl + Pause/Break.
RBS "dim" wrote in message ... Hi folks....this is a bit embarrasing! I created a crappy bit of code by accident in my auto-open macro, and can't get into my program to delete it! Can someone tell me the key combination to stop running code while its executing? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
Hi
hold shift pressed when you open the file. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "dim" wrote: Hi folks....this is a bit embarrasing! I created a crappy bit of code by accident in my auto-open macro, and can't get into my program to delete it! Can someone tell me the key combination to stop running code while its executing? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
as always, there're a few ways to accomplish this. wigi gave you one, you can also set the macro security to very high, then open your file. or, start excel in safe mode, this is an example for excel 11 "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /s -- Gary "dim" wrote in message ... Hi folks....this is a bit embarrasing! I created a crappy bit of code by accident in my auto-open macro, and can't get into my program to delete it! Can someone tell me the key combination to stop running code while its executing? Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
Thanks folks,
Holding Shift worked a charm. Setting Macro security seems like a really obvious solution...I should ahve thought of that! L8rs. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Endless Loop - Shortcut Key To Stop Code?
OK, misread the question.
RBS "dim" wrote in message ... Thanks folks, Holding Shift worked a charm. Setting Macro security seems like a really obvious solution...I should ahve thought of that! L8rs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting endless loop on DoUntil | Excel Programming | |||
Endless loop | Excel Programming | |||
endless loop help | Excel Programming | |||
Endless loop? | Excel Programming | |||
Interrupting an endless loop | Excel Programming |