A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Instead of debugging, code just stops running



 
 
Thread Tools Display Modes
  #1  
Old August 13th, 2008, 07:06 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default Instead of debugging, code just stops running

I have a macro that gets to a point where it should hit an error and debug
but instead it just stops running. I can then access the spreadsheet and
make any changes I want, which I shouldn't be able to do. Any ideas why this
is happening? The error is coming because the macro tries to update links to
an external worksheet but the current spreadsheet is not linked to the
external one.

Thanks

Adam Bush
  #2  
Old August 13th, 2008, 07:26 PM posted to microsoft.public.excel.misc
Kevin B
external usenet poster
 
Posts: 1,237
Default Instead of debugging, code just stops running

You might want to consider posting your code, it will make it easier to get
some assistance.

Have you tried opening the VBE (Alt + F11) to step through the macro 1 line
at at time by pressing F8. Move your cursor to a any location within the
macro and press F8. A highlight appears to indicate which line is being
executed, press F8 again to process the line and repeat until either all
lines have been executed (indicating that there are no errors) or until an
error is encountered. At least you'll know where the error is occurring.
--
Kevin Backmann


" wrote:

I have a macro that gets to a point where it should hit an error and debug
but instead it just stops running. I can then access the spreadsheet and
make any changes I want, which I shouldn't be able to do. Any ideas why this
is happening? The error is coming because the macro tries to update links to
an external worksheet but the current spreadsheet is not linked to the
external one.

Thanks

Adam Bush

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 AM.


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