Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a double click event for cell? | Excel Discussion (Misc queries) | |||
userform label double-click goes to click event | Excel Programming | |||
Can you capture worksheet double click event from an Add-In???? | Excel Programming | |||
Sheet After Double Click event? | Excel Programming | |||
Before Double Click Event | Excel Programming |