Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Pause A Macro using Keystroke

Status
Not open for further replies.

NYFashionToGo

Technical User
Jan 16, 2007
76
US
Okay I have a little problem here that I need to correct. I already tried pressing the ESC button, however this just closes out excel.
Here is what the problem is.
I was in process of creating an application using windows scheduler to Launch Excel by itself and upon launching it begins a macro all by itself. To Download some files for updating off the internet. I just added a close command to to the code. It is giving me problems because now I can not get inside the visual basic editor to edit it or take it out. Is there a trick or keystroke to stop the macro, just so i can remove the close part and have the versitility of editing it. I tried using ESC it closes excel. Any help would be appreciated.
Thanks
 
Okay I found the Answer just by fooling around pressing some keys. If anyone needs to know, ctrl and PauseBreak keys pressed at same time gives a prompt to continue debug, resume,or Help.

whew!! I thought I lost alot of work there.

A new Question, Does anyone know of a list of all the keystroke commands? Something for reference. Just curious

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top