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.

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.

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.

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.

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.

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.