Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeDoubleClick on Protected Sheet
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeDoubleClick on Protected Sheet
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With BeforeDoubleClick | Excel Programming | |||
Protected cells in Protected sheet | Excel Programming | |||
BeforeDoubleClick | Excel Programming | |||
beforedoubleclick and selectionchange | Excel Programming | |||
BeforeDoubleClick doesn't seem to work | Excel Programming |