Protect and unprotect Pivot table

[Guest]

Hi,

Is there any way we can protect and unprotect the pivot table only through
macro not the whole sheet?

Thanks

 

[Frank Kabel]

Hi
you can only protect the whole sheet BUT you can try the following:
- select the other cells
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- NOW protect your worksheet

 

[Tom Ogilvy]

Use the
Activesheet.EnablePivotTable
Activesheet.Protect Password:="ABC", UserInterfaceOnly:=True

This must be done each time the workbook is opened as the EnablePivotTable
and UserInterfaceOnly settings are not persistent across the closing of a
workbook (so use the workbook open event as an example. )