BeforeDoubleClick on Protected Sheet
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 !!
"Charlie" wrote:
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!
"Paul" wrote:
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.
|