Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Step Dialog Box
At seemingly random intervals I am prompted with the Single Step
dialog box asking me if I want to Step Into, Evaluate, etc. The problem is, the only way I can regain control of the application is to use Ctrl-Alt-Del and kill the program. I must first copy all unsaved VBA to a Word doucment with keyboard commands for pasting back into the module after restarting Excel. This dialog box is waiting for a responce from me but it does not seem to accept any responces. How do I get rid of this dialog box. It started popping up about a week ago. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Step Dialog Box
Send this part of code which You are using for open dialog
box and get returned value. -----Original Message----- At seemingly random intervals I am prompted with the Single Step dialog box asking me if I want to Step Into, Evaluate, etc. The problem is, the only way I can regain control of the application is to use Ctrl-Alt-Del and kill the program. I must first copy all unsaved VBA to a Word doucment with keyboard commands for pasting back into the module after restarting Excel. This dialog box is waiting for a responce from me but it does not seem to accept any responces. How do I get rid of this dialog box. It started popping up about a week ago. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Step Dialog Box
Hi Michael,
This can be a symptom of corruption in your project. Download the VBA Code Cleaner utility from my web site below and run it on your project. Let me know if it helps. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Michael Thompson" wrote in message om... At seemingly random intervals I am prompted with the Single Step dialog box asking me if I want to Step Into, Evaluate, etc. The problem is, the only way I can regain control of the application is to use Ctrl-Alt-Del and kill the program. I must first copy all unsaved VBA to a Word doucment with keyboard commands for pasting back into the module after restarting Excel. This dialog box is waiting for a responce from me but it does not seem to accept any responces. How do I get rid of this dialog box. It started popping up about a week ago. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Step Dialog Box
After running the VBA code cleaner utiliity, I have not had any more
problems. Thanks very, very much, great tool. "Rob Bovey" wrote in message ... Hi Michael, This can be a symptom of corruption in your project. Download the VBA Code Cleaner utility from my web site below and run it on your project. Let me know if it helps. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Michael Thompson" wrote in message om... At seemingly random intervals I am prompted with the Single Step dialog box asking me if I want to Step Into, Evaluate, etc. The problem is, the only way I can regain control of the application is to use Ctrl-Alt-Del and kill the program. I must first copy all unsaved VBA to a Word doucment with keyboard commands for pasting back into the module after restarting Excel. This dialog box is waiting for a responce from me but it does not seem to accept any responces. How do I get rid of this dialog box. It started popping up about a week ago. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Excel 2002: Can I protect the whole file in a single step ? | Excel Discussion (Misc queries) | |||
Excel 2002: Single step of selecting characters | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |