Unprotecting workbook when drilling into a pivot table row

[stubarny]

Hello,

I have a pivot table that I need users to be able to double click in order to drill into a row detail - causing a new worksheet to be created.

My problem is that I need the workbook to be protected and this protection is preventing the pivot table drill down.

Please could you tell me how I can unprotect the workbook whilst carrying out this event and then re-protect the workbook when the event is finished?

(I was thinking of using Worksheet_BeforeDoubleClick to unprotect the workbook but do you know of an equivalent procedure for "after" the double click event (so that I can re-protect the workbook)?

Many thanks,

Stu

 

[stubarny]

Fix:

before double click event:

Worksheet_BeforeDoubleClick

after double click event (just remove the Before from the procedure name to get to the equivalent "after" procedure name):

Worksheet_DoubleClick