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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|