Instead of debugging, code just stops running

A

adambush4242

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
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Stops Running Instead of Debugging 1
External Data Refresh all just for one worksheet 3
Check File Name With Conditional Statement 1
Running a Macro through a button vs. VBA 2
Updating Links in a Protected Sheets 2
Open and Close a Workbook to Update Links 3
background commands running in Excel? 1
Problems with Bloomberg External Links 1

Top