Hi All,
I know error handling can be tricky.
So i have this in some code i am working on. i just want to make sure i am doing it correctly.
I have this at the very top:
This is at the very bottom"On Error GoTo ErrHandler:
This code is copying data from another open workbook, then pasting into this one.Exit Sub ErrHandler: ActiveSheet.Protect MsgBox ("You did not open ''UCPSITE-06.xls''")
If the other workbook is not open, i want to exit sub and show message box.
It seems to be working, but i wanted to get a guru's opinion.
Bookmarks