View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Double Click Event Error on Worksheet

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