Without posting your code it is pretty difficult to diagnose. Sounds like
the UserForm initialize event is causing the error? Post both codes sets.

--

Regards,
Nigel




"RyanH" wrote in message
...
I have a Worksheet that my users use to quote particular jobs. The entire
worksheet is locked and protected. The only way they can add/edit data is
via a UserForm. When they add a particular product, a cell labeled "Edit"
is
unlocked. I have a Before Double Click Event that the user uses to double
click that cell and the UserForm shows up to make edits.

My issue is when there are no products on the worksheet. The entire sheet
is locked and protected. When I double click something an error shows up.
I
don't want this to confuse the User. Is there a way to ignore that
particular error, but show other errors for debugging? Or have a MsgBox
show
up saying something?

Thanks,
Ryan