BeforeDoubleClick on Protected Sheet

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I use BeforeDoubleClick on a number of protected sheets, and it works
perfectly.

I have one particular model which has a protected sheet, the cell being
accessed is unlocked, validation on the cell being double-clicked and it will
only work when the sheet is unprotected.

I have tried placing a breakpoint on the worksheet code, but it doesn't seem
to get called.
 
That's true. You seem to have hit on a quirk. When the sheet's protected it
seems to skip the BeforeDoubleClick and go directly into data validation.
Cells without data validation don't skip the event. I don't know what to
tell you to do to fix it but I've made note of it for my own reference!
 
My workaround is to remove the Excel data validation, then code my own
validation using Worksheet_Change, then application.INDEX (or match or
vlookup) to look up the entry in the required list. Not very pleasant but
leaves the double click operative !!
 
Back
Top