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:

Code:
--------------------
On Error GoTo ErrHandler:
--------------------


This is at the very bottom"

Code:
--------------------
Exit Sub
ErrHandler: ActiveSheet.Protect
MsgBox ("You did not open ''UCPSITE-06.xls''")
--------------------

This code is copying data from another open workbook, then pasting into
this one.
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.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=560960