View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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.