ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Single Step Dialog Box (https://www.excelbanter.com/excel-programming/284814-single-step-dialog-box.html)

Michael Thompson

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.

losmac[_2_]

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.
.


Rob Bovey

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.




Michael Thompson

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.



All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com