Excel 2007 - Drill-through action called via VBA locks the workshe
 

Hi,

In excel 2007 I am calling for a OLAP cube which has drill-through action
setup in it. Using VBA if i call for the drill through action, the worksheet
created
using drill through is protected and it cannot be unprotected (the area to
unprotect is greyed out). If I call for the drill-through action without
using VBA then the worksheet is not protected.

The code I am using to call for the drill through action is
ActiveCell.ServerActions("driildetail").Execute
This code is in the workheet area where the pivot table with cube data is.

If I right click from the pivot table and select the drill-through action
then the sheet created is not protected. It is protected only when called
from VBA
Is there any way the worksheet created from a drill through action be
unprotected programmatically. Activeworkbook.unprotect or
activesheet.unprotect does not work.

Thanks.

SG