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

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