Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Drop Down List with Step by Step Instructions for 2007 remarkable Excel Worksheet Functions 2 March 22nd 09 04:36 AM
Excel 2002: Can I protect the whole file in a single step ? Mr. Low Excel Discussion (Misc queries) 3 August 30th 07 02:12 PM
Excel 2002: Single step of selecting characters Mr. Low Excel Discussion (Misc queries) 5 May 4th 07 05:12 PM
What is the step-by-step procedure for making a data list? Bobgolfs56 Excel Discussion (Misc queries) 1 April 23rd 05 02:19 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"